Ignore the Dashboard filter for one of the columns

[Srav_Sense]

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)

[Harry · Accepted solution]

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]

Thank you so much @HarryHarry It worked!