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

Ask the Community
1

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

image
image1584×991 99.9 KB

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.

image
image1580×979 104 KB

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

running_total(
  ecommerce_users.id | count() ,
  ecommerce_users.sign_up_date
)
1 Like
2

By default, the running total will be calculated after filtering (keep_filters: true ). To calculate a running total of all data, ignoring any filter on the running dimensions, you can add a keep_filters: false parameter to the function.
Here is a comparison between keep_filters: true and keep_filters: false :

1736×704 135 KB

Playground Sample

2 Likes
3

Thanks, it works like a charm @tan