Hi community,
I have a use-case wherein I have to do a group by date and plot some values on Graph. I am aware of the “timeGroup” function provided by Grafana to do the grouping and also the fact that it can fill 0 values when a particular date’s value is NULL. But this has some issue. Let’s say, in the database(I am using PGSQL), the first value of date is 11/9/2020. Then using “timeGroup” function, I am able to get zero values for dates after 11/9/2020 if any date is missing in the Database, but it also makes values of the dates before 11/9/2020 as zero. I only want to have zero values after the first date in the database. Can anyone please provide a solution for this.
