I’m looking to graph the full set of values in a time series for the series that have the top 100 point values in that time. Don’t seem to be able to do it.
One way to set a threshold is to include another WHERE clause.
For example:
SELECT count(“amount”)
FROM “AUTH”
WHERE (“gateway” =~ /^$gateway$/ AND “provider” =~ /^$Provider$/)
AND $timeFilter
AND "amount" > <threshold>
GROUP BY time(1m), “terminalNumber” fill(null)
I thin that only shows the individual points that are above the threshold, which creates an almost invisible graph.
What I need is effectively to:
show the full graph for the entire timeframe for the terminals that have to 20 highest values at any point in that timeframe.
Effectively I’m only looking to see the most important 20 terminals, the ones that peak highest.
The problem you are trying to solve is tricky because you want to evaluate all of the series first — which then results in some subset of the actual series you are interested in.