I am making a table and would like to show the total number of hours/minutes/seconds that the value of my table shows values of 1 or greater. There’s sometimes gaps greater than 5 mins. I don’t want to use that time gap in my calculations. I’m trying to grab a years worth of data and there’s gaps and it’s still calculating the buffer zones. Thank you
welcome @xbenbendx
Can you share what your data source is and what the data looks like in the datasource and what you want the final result to look like?
We use postgres as datasource. I would set up a postgres view that contains the data as I want to have it show.
If you can explore a bit more on which data in which datasource you have, more concrete hints might be possible.
Also, how you imagine the total number of hours/…/seconds > 1 shown. If that is easier, you could set up a manually drawn or Excel graph.