I have a dataset with readings every 30m. I want to set a start time and an end time at a single interval (eg 1:00 - 1:30) and rank the devices based on the amount they changed. I've been using the Top N feature in TSVB. I've started off by creating a TSVB with a Max aggregation followed by a Derivative of the Max and lastly a Positive Only of the Derivative and grouped by my device.
I think the problem is the ordering because I get many 0 results and the only way to get more positive results is to increase the Top # which also increases the number of 0 results. I'm guessing it has to do with only being able to order by the Max aggregation not the Derivative of Max. Perhaps related to:
Is there any way around this ordering issue?