Forum Discussion

CLewis's avatar
CLewis
Cloud Apps
02-02-2023

Filter by two values on same widget

Anyone know how I can filter two values independently? In the chart below the first 4 bars are from my "days in R/I stage formula. The next 4 are related to the Insulation-Prime formula.

Each formula has a filter built in to only look at jobs from the stage they are in. But I also want to be able to filter these by different numbers. 

"Current days in R/I" should only show jobs over 15 days. Where "Current days in insulation/prime" I want to see anything over 10 days. 

 

 

 

 

 

Blox
dashboards & reporting
Finance Analytics

1 Reply

Replies have been turned off for this discussion
  • david-h's avatar
    david-h
    Cloud Apps
    02-03-2023

    Hi,

    Not sure If I understand exactly what you are already doing today. But it looks like your need can be met by one of this two way :

    1) include a filter in the formulas for the two KPIs, by date, with a period date filter. If you already have a filter in the formula, you can add many ones, by adding commas => ([Total of MyIndicator], [Filter 1], [Filter 2], ...)

    2) use "Filtered Measure" add-on from Sisense, that will let you define two different values for the same field, and direct KPI1 to use the first filter and KPI2 use the second filter. Here is the link to the add-on : Add Ons | Marketplace - Sisense

    Let me know if you additional info.

    Best,