Variance/Deviation Visualization

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?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.