I want to plot 2 simple graphs using the following queries:
SELECT
time,
sum(cons.volume) as measured
FROM (
select distinct on(time,ams_entity_name)
time,
value as volume
FROM ${db}.inputs_v1
WHERE series=‘ams_measurement’
order by time, insert_time desc
) cons
GROUP BY time
order by time
SELECT
time,
sum(abs(cons.volume))/2 as settlement
FROM (
select distinct on(time,name)
time,
volume as volume
FROM ${db}.lfm_settlement_v${version}
order by time, insert_time desc
) cons
GROUP BY time
order by time
And when I want to plot them I can only see Query B over 2 days.
When I zoom out though, I can see both of the graphs.
What could be the problem?