MySQL Multi Value Time Series Assistance

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

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

Check this out

Multi values by using Transformation

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

1 Like

That did it thank you so much!

1 Like

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

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