Values are mixed up if 1+ variable values are selected

Grafana Time Series Panel
1

I try to create a graph panel based on daily data with 2 queries. 1st query is the total sum per day and the 2nd query is a part of that. If I select 1 value of my variable dropdown list everything looks as expected:

grafana_graph_fine
grafana_graph_fine1329×461 9.68 KB

But if I select a 2nd (or 3rd, …) value of the variable dropdown the whole graph is crashed:

grafana_graph_error
grafana_graph_error1323×462 7.75 KB

In both options the result of the queries are the same:
Date in time format, value 1 integer, value 2 integer

In both cases there is one row for each day.

For me it feels like the queries are fine but the panel settings are wrong. Can you assist where the wrong setting is hiding?

2

I think I can’t edit my post but I want to share the solution.

As easy as expected but difficult to understand: The SQL Queries didn’t contain the “Order by time” statement.