How to create a running total that excludes visualization or dashboard filters

The total number of users as of the latest month (May 2024) is 10,264.

However, when I apply visualization filters or dashboard filters, the total number of users for the latest month is only 3,824, whereas I want it to be 10,264.

This is my current AQL metric for calculating the running total:

running_total( | count() ,
1 Like

You can replace running_total with running_total! | Holistics Docs (4.0). It’s a drop-in replacement which do exactly that.

Playground Sample


Thanks, it works like a charm @tan