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
[email protected]
www.qbeeq.pl

[Srav_Sense]

Thank you so much @HarryHarry It worked!

[Wojtek]

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]

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]

@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 🙂