Hello
I am using grafana to visualize data from my rain-sensor. As my rain sensor zeros at 0700 everyday I have to calculate values from 0000 - 2400. While I was able to calculate values for my daily bar chart
SELECT SUM(nnd)
FROM (
SELECT NON_NEGATIVE_DIFFERENCE("value")
AS nnd FROM "mm"
WHERE $timeFilter
) time(1d)
I got stuck when I want to generate a cumulative sum of those values over the selected period. The following query returns the error aggregate function required inside the call to cumulative_sum
:
SELECT CUMULATIVE_SUM(nnd)
FROM (
SELECT SUM(nnd)
FROM (
SELECT NON_NEGATIVE_DIFFERENCE("value")
AS nnd FROM "mm"
WHERE $timeFilter
) GROUP BY time(1d)
) GROUP BY time(1d)
Can anyone explain why this isn’t working (the errormessage does not make a whole lot of sense to me).
Thank you
PS: full story here