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 fo...
Forum Discussion
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,
