Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
02-03-2025
Solved

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 ...
dashboards & reporting
  • AssafHanina's avatar
    AssafHanina
    02-04-2025

    Hey 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

  • Liliia_DevX's avatar
    Liliia_DevX
    02-04-2025

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

Astroraf's avatar
Astroraf
Data Pipeline
02-07-2025

Hi 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_DevX's avatar
    Liliia_DevX
    Sisense Employee
    02-07-2025

    Astroraf 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: