I have a time-series data which is ingested daily. I am using TSVB Time Series graph to do a filter ratio calculation to get the percentage of good records (Basically filter for good records divided by Total).
Currently the calculation is done per 1 day (the defined interval) and I see the success ratio on a daily basis on the graph for that day. What I need though, is to be able to calculate the success ratio, everyday over the entire data set since the beginning to present (not just for the past day).
For instance, let's say we started ingesting on Jan 1st, 2020. On Januray 5th, 2020 I need to see the success percentage from Jan 1st to Jan 5th on the graph. On Jan 6th, I need to see the success percentage from Jan 1st to Jan 6th on the graph. On present day I need to see the result from Jan 1st to today (and so on).
Could anyone suggest a way to do this using either Timelion or TSVB? I prefer TSVB since I am more familiar with it.
Thanks in advance