Hello everyone.
Here is the following request:
SELECT
SUM("slotRenderEnded"::float) slot_Render_Ended, date_bin(INTERVAL '$GROUP_BY_TIME_SQL', time) as time, extension
FROM
"productionAscScrollViewabilityDebug"
WHERE
"time" >= $__timeFrom AND "time" <= $__timeTo
AND state = 'completed'
group by
extension, time
order by time
The following request outputs the sum of slotRenderEnded
at each time interval. The problem is that instead of displaying the sum of all values in a single time interval, only one value is displayed. Could you please advise if this could be an issue with data conversion or with the request itself?