Solved
Ignore the Dashboard filter for one of the columns
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)
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
