Forum Discussion

Astroraf's avatar
Astroraf
Data Integration
11-21-2025
Solved

How to have dashboard filters affect a formula filer?

Hi DRay​ ,

I have this formula in Sisense Bar Chart: 

(((([Total CLAIM_CNT]) )/([Total CLAIM_CNT],Prev([@Months in DATE], 12),([@Network Name])))-1)

Where I have the Category being Network Name, I also have the Network Name in the Dashboard filter but when I select a Network Name in the Dashboard filter the widget does not filter for my selected Network Name. The Network Name being in the Denominator is to get the Total Claim Count. I also know that the hierarchy for filtering in Sisense is Formula Filter > Widget fitler > then Dashboard filter. 

Is there anyway to override this behavior? I still need to the overall claim counts to get the percentage by individual network names but still want to filter for the specific network name. 

 

dashboard design
dashboard filter
Filters
Formula Filters
formulas
  • AssafHanina's avatar
    AssafHanina
    12-02-2025

    Hey Astroraf​ ,

    In the share syntax, the issue is in the Prev Function.
    Prev function accept the Time Field as Dimension and not as filter.
    The syntax should be prev([Months in Date],12) without the @ sign. 

    The filter should apply outside of the Prev function same as the Network Name. 
    Suggest to test the syntax and behavior on the Aggregation, for example: (sum([Total Value]),[@Months in Date])
    to make sure that the plugin behavior works as expected. if not, please raise a support ticket

    Best regards

6 Replies

  • DRay's avatar
    DRay
    Journey Map
    11-25-2025

    Hi Astroraf​,

    I don't have an answer for you, but I have reached out internally to see if someone else knows.

  • AssafHanina's avatar
    AssafHanina
    Sisense Employee
    11-25-2025

    Hey Astroraf​ ,

    It looks like a Filtered Measure syntax where the value of the Category in the Network Name filter should be update once the dashboard filter is change. 

    This can be done with the filtered Measure plugin and the formula use the syntax for it, i.e: @filter_name 

    The following describe the syntax and related examples.
    follow the implementation to resolve the issue

    FYI DRay​ 

    • Astroraf's avatar
      Astroraf
      Data Integration
      12-01-2025

      Hi AssafHanina​ ,

      I am using the Filter measure plugin but it does not seem to be doing what I want it to be doing

      • AssafHanina's avatar
        AssafHanina
        Sisense Employee
        12-02-2025

        Hey Astroraf​ ,

        In the share syntax, the issue is in the Prev Function.
        Prev function accept the Time Field as Dimension and not as filter.
        The syntax should be prev([Months in Date],12) without the @ sign. 

        The filter should apply outside of the Prev function same as the Network Name. 
        Suggest to test the syntax and behavior on the Aggregation, for example: (sum([Total Value]),[@Months in Date])
        to make sure that the plugin behavior works as expected. if not, please raise a support ticket

        Best regards

  • DRay's avatar
    DRay
    Journey Map
    12-01-2025

    Hi Astroraf​,

    I’m following up to see if the solution offered by AssafHanina​ worked for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.

  • DRay's avatar
    DRay
    Journey Map
    12-12-2025

    Hi Astroraf​,

    I’m following up to see if the solution offered by AssafHanina​ worked for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.