Gauge with max count


(Mike W) #1

Please help me to figure out how to create a gauge where:

  • max is based on the total unique count of particular field (in my case this is total unique number of logins)
  • gauge value is based on total unique count of particular field (in my case this is total unique number of logins) BUT between specified time range (now-4w/w - now)

(Jen Huang) #2

You can do this with the Time Series Visual Builder gauge using a Bucket Script.

My example shows the count of the past 6h (Interval setting) as a percentage of the last 7 days (time range filter at the top).

I use the Count aggregation (gives me the total within the last 6h), as well as a Cumulative Sum on the Count aggregation (the total within the last 7 days). Then, I use a Bucket Script to calculate the percentage.

Lastly, I format the value as Percentage in the Data Options.




(system) #3

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