I imported some data into a MySQL Database. I plot the data in a graph but for some reason it splits up the data into different colors, eventhough it shouldn’t. See picture below.
I would like that all entries with the same name are also in the same color.
Here my code:
SELECT $__timeGroup(timestamp,$interval,NULL) as time_sec, sum(Amount) as value, Partname as metric FROM statistik WHERE $__timeFilter(timestamp) GROUP BY 1 ORDER BY 1
What maybe is also good to know is that I did not import all the data at once. The changing color occurs when I add a new measurement over time. In the MySQL database all the partnames look the same to me.
The database looks like this:
| Timestamp | Partname | Amount |
| - datetime - | — text — | - int(11)- |
Can you help me with this issue?