cancel
Showing results for 
Search instead for 
Did you mean: 

Ignore the Dashboard filter for one of the columns

Srav_Sense
9 - Travel Pro
9 - Travel Pro

I need to display a totals column, one in which the value should be filtered by the dashboard filter (date) and the other should the total value (ignoring the dashboard filter)

1 ACCEPTED SOLUTION

Harry
9 - Travel Pro
9 - Travel Pro

Hello @Srav_Sense ,

You can ignore a filter in formula using 'All' function.

For example, if you want find total amount, but by ignoring date filter, the formula would be:

(COUNT([AMOUNT]), ALL([DATE]))

Note: the granularity of date in filter and formula should be same. i.e. If filter is showing months, 'Months in Date' should be selected in formula.

Here is the documentation about the function: https://documentation.sisense.com/docs/function-references#all

Please let me know if you have any questions

Always here to help,
Harry from QBeeQ
harry.km@qbeeq.pl
www.qbeeq.pl

View solution in original post

5 REPLIES 5

Harry
9 - Travel Pro
9 - Travel Pro

Hello @Srav_Sense ,

You can ignore a filter in formula using 'All' function.

For example, if you want find total amount, but by ignoring date filter, the formula would be:

(COUNT([AMOUNT]), ALL([DATE]))

Note: the granularity of date in filter and formula should be same. i.e. If filter is showing months, 'Months in Date' should be selected in formula.

Here is the documentation about the function: https://documentation.sisense.com/docs/function-references#all

Please let me know if you have any questions

Always here to help,
Harry from QBeeQ
harry.km@qbeeq.pl
www.qbeeq.pl

Srav_Sense
9 - Travel Pro
9 - Travel Pro

Thank you so much @HarryHarry It worked!

Wojtek
9 - Travel Pro
9 - Travel Pro

ALL function appears to have stopped working with new Analytical Engine enabled - im on L2023.2.

Does anyone have an idea of alternative solution?

 

 

zach_myt
9 - Travel Pro
9 - Travel Pro

Even with using ALL the Values are still affected by the date filter when using division. I am version L2023.7.0.211.  Also, the link https://documentation.sisense.com/docs/function-references#all does not work, please update.

Wojtek
9 - Travel Pro
9 - Travel Pro

@zach_myt you could create dummy date rows as workaround but its not great , plus you would have to do it for all dimensions , not just date. If you try this or find some other workaround let us know 🙂