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(
  ecommerce_users.id | count() ,
  ecommerce_users.sign_up_date
)
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

2 Likes

Thanks, it works like a charm @tan