Calculated field not affected by filter

Q&A
, , ,
1

Hello,
I want to make a calculated field, let’s say of the average score for all users
I want it to keep the average of all users even if I use a filter for a specific user (I want to use it as a benchmark)
How should I do that?
Thanks!

2

Hi @InbalK

You can use the PRE_FILTER aggregation level

Here’s an example:

  1. All Data (See the average with PRE_FILTER and the Avg at the bottom of the table is the same

image
image667×572 41.1 KB

  1. Now filter data to get a sub-set. See the change in the avg. The average with PRE_FILTER still computes based on all data. However, the avg computed without it is computed for the filtered data

image
image651×518 33.2 KB

  1. Calculated field

image
image738×141 4.32 KB

I hope this is what you were looking for.

Regards,
Giri

1 Like
3

Thank you @Giri !
Now, if I want the date filter to influence? I mean- I want to show the average for all users in the selected time (even if I filter a specific user)

4

Hi @InbalK,

In regards to your follow up, you’ll either need to recognize all filters or none by using the ‘PRE_FILTER’. Quick Suite does not allow the use of mismatched aggregations and if you use pre-filter, it will ignore ALL filters being applied.