HTML tables filtering

art_in_sky

I have 5 columns and have a beast mode calculation that indicates risk level based on the value range, now i am finding it challenging to filter the rows by risk indicator

MarkSnodgrass

On your 3 slicer cards, you can edit the dashboard and choose change interaction for each of them and de-select the other two slicer cards to keep them from reacting to each other.

MarkSnodgrass

A couple thoughts on this:

The first thing I would try would be to re-order your WHEN statements so that all of your Low Risk items are first, followed by the Medium Risk and then the High Risk items. Since case statements stop evaluating once they find a match, if you want someone to be low risk if they meet any of those criteria, this solution will work for you.

If an entity is only low risk, for example, if they meet all of your criteria, then I would restructure so that you only have 3 WHEN statements (1 for each risk) that have a lot of AND statements in them as you are combining each risk.

Hope this helps.

art_in_sky

@MarkSnodgrass When I reorder them by low risk, high risk. Wouldn't the low risk rows stop getting evaluated when checking for high risk? For instance my condition is to check if it evaluation meets true for any of the conditions among five columns.

MarkSnodgrass

The way your original case statement is constructed, and assuming that all rows have the Leverage Ratio column populated with the string Leverage Ratio and the Leverage Ratio Values column has a value in it, then only the first 3 WHEN statements will ever be used in your evaluation because CASE statements automatically exit once they find a match.

Let me ask a question that might help me offer a solution. If someone is classified as Low Risk when evaluating their Leverage Ratio, and classified has Medium Risk when evaluating their Cash On Hand, and High Risk when evaluating their Profit/Loss Margin, and Medium Risk when evaluating their Current Occupancy, and High Risk when evaluating their % of active beds, and Low Risk when evaluating their LHC Strength, what risk would you actually classify them?

art_in_sky

@MarkSnodgrass 5 COLUMNS- IF ANY COLUMN HAS LOW RISK THEN DISPLAY UNDER LOW RISK
MEDIUM RISK- IF ANY COLUMN HAS ATLEAST ONE MEDIUM RISK, THEN DISPLAY UNDER MEDIUM RISK
SAME FOR HIGH RISK

Rows displayed under high risk can be displayed under low risk and medium risk as well if they have atleast one such indicator

art_in_sky

@MarkSnodgrass
I created individual risk indicators (Beast Modes) for 'Low,' 'Medium,' and 'High' using OR conditions and added separate slicer cards for each risk. However, when filtered, the slicers display 'Null values' with the 'selected values' language. Is there a way to remove this language and display the slicer filters as buttons for selection instead?

MarkSnodgrass

On your 3 slicer cards, you can edit the dashboard and choose change interaction for each of them and de-select the other two slicer cards to keep them from reacting to each other.

art_in_sky

@MarkSnodgrass
Thank you! This one is hopefully resolved.