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
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