MySQL Multi Value Time Series Assistance

Grafana Dashboards
1

I have been trying to get multi value time series with MySQL to work and it just shows up with one value and one line.

Here is my query, how can I break out all entity_ids and values to produce the multi line?

SELECT CAST(last_updated AS DATETIME) as TIME, 
CAST(state AS DECIMAL) AS DATA,
entity_id AS device 
FROM ha_db.states  
WHERE $__timeFilter(last_updated)
AND entity_id in ('sensor.mpp_lvx6048wp_ac_output_total_apparent_power' AND 'sensor.mpp_lvx6048wp_ac_input_total_active_power') 

ORDER BY last_updated ASC

TIA

2

Is this even feasible in grafana? I have seen examples just not with MySQL that work. Is MySQL the issue ?

3

Check this out

https://localhost:3000/t/timeseries-with-postgresql-is-displayed-a-single-graph-with-group-by-1-2/80384

Multi values by using Transformation

4

Thanks I will take a look, I was looking at transformations but could not work it out.

1 Like
5

That did it thank you so much!

1 Like
6

It should really be a default not a transformation. It trips up many people including me

7

agreed, I work in a couple tools like this and it is not easy to find!