How to have the secondary value in an Indicator Widget not be affect by Dashboard Filters
Hi DRay Liliia_DevX ,
I am curious: if a customer wants to have a formula in the second indicator widget not affected by the dashboard filters, how would one go about doing this?
My solution would be:
COUNT(coloumn_name, ALL(dim_value))
Would this be correct?
Rafael Ferreira
Posted 1 year ago·Last reply 1 year ago
6 comments
Rafael Ferreira
OP1 year agoHi Liliia_DevX and AssafHanina,
I have another step to this process. Not sure if it has already been asked, but I need a calculation to not change with any filtering. How would I achieve this?
Liliia Kislitsyna
Admin1 year ago · EditedAstroraf hi!
The only way to do that on a formula level is to include all dimensions used in filters with ALL() function.
Another approach is to create an indicator with one value and just toggle off all dashboard filters in the widget edit mode:
Rafael Ferreira
OP1 year agoAssafHanina Thank you got this solution. My only question is say I have multiple filters. Could this still apply?
example: SUM(COUNT([ID]), ALL([dim_val1], [dim_val2], [dim_val3]))
Liliia Kislitsyna
Admin1 year ago · EditedAstroraf hi! If you like to have multiple dimensions not be affected by dashboard filters, the syntax should look like on the screenshot below:
Feel fee to test it from your side 🙂
Assaf Hanina
·1 year agoHey Astroraf ,
Please find Liliia syntax below
Best Regards
Assaf Hanina
·1 year ago · EditedHey Astroraf ,
The Syntax shared is a valid solution.
The ALL Function ignore the scope of the filter (See related documentation)
Example of Using the same measure twice with and without All Function
Best regards