i am trying to get daily consumption from smartmeter table for each week from aws timestream but its returning all the data thats the smartmeter has used SELECT
date_trunc(‘week’, CURRENT_DATE),
meter_id,
MAX(CASE WHEN measure_name = ‘ActEnPosT1’ THEN measure_value::varchar END) AS value_actenpost1_10m
FROM
“mykrogrid”.”smart_meter1.0″
WHERE
time BETWEEN ago(24h) AND NOW()
AND measure_name = ‘ActEnPosT1’
GROUP BY
date_trunc(‘day’, time),
meter_id`;

SELECT
date_trunc(‘week’, CURRENT_DATE),
meter_id,
MAX(CASE WHEN measure_name = ‘ActEnPosT1’ THEN measure_value::varchar END) AS value_actenpost1_10m
FROM
“mykrogrid”.”smart_meter1.0″
WHERE
time BETWEEN ago(24h) AND NOW()
AND measure_name = ‘ActEnPosT1’
GROUP BY
date_trunc(‘day’, time),
meter_id`;