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.
Rafael Ferreira
Posted 8 months ago·Last reply 7 months ago
6 comments
DRay
·7 months agoHi 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
·8 months agoHi 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.
Assaf Hanina
·8 months agoHey 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
Rafael Ferreira
OP8 months agoHi AssafHanina ,
I am using the Filter measure plugin but it does not seem to be doing what I want it to be doing
Assaf Hanina
·8 months agoHey 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
·8 months agoHi Astroraf,
I don't have an answer for you, but I have reached out internally to see if someone else knows.