Pre Filtering for one category and NOT the Others

Question & Answer
, , , ,
1

Greetings,

I have three filters on my QuickSight dashboard page.

I want to Pre-Filter for one of them but still be able to use the other ones.
Does anyone know how I might achieve this?

2

Hi, have you tried using PRE_FILTER level aware calculation function?

3

Yes I did.

The problem is that when I use PRE-FILTER it ā€œpre-filtersā€ all of the filters in the dashboard page.
So I have three categories that I have filters (Name of Employee, New Vs Renewal and Grade).

I need to be able to pre-filter only for Name of Employee and still be able to use two other filters on the dashboard page.

If you have any idea, I would be very thankful to hear it.

4

I see, then you should be able to use the PRE_AGG so it only applies to Name of Employees. This follows the order of evaluation on QuickSight.

1 Like
5

We can try this. If you can live with single select filters, you could change them to parameter filters, which can adjust where it happens in the pipeline. You create two parameters and add a control for each (can tie to to the same fields to populate the values).

Then make a calculation like this that will apply those parameters to this metric specifically (not the whole visual).
ifelse(field1= $param1 AND field2= $param2, value, NULL)

Then you can reference this field in your other calcs like your LAC, but use PRE_AGG (not PRE_FITLER).

Then the 1 filter you want to apply to as ā€˜pre filterā€™ add as a normal filter to the visual. It should happen before your other parameter filters are applied.

6

This one workedā€¦ Thank you!

1 Like
7

Hey,
I have the same issue and I donā€™t clearly understand how to do the solution you suggested.
I have 10 Filters in my analysis, and I want to have pre_filter aggregated column that will ignore only 1 filter and not all 10 filters.

How Can I solve that with your solution?