Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following columns (among others) in a straight table.
Provider (dimension, and controlled by a filter)
Failed3Day (expression)
I have a button that I want to use to show only providers that have the 20 highest values, and sort the table on the Failed3Day column from highest value to lowest.
I assume that I want to create a "Select Field" action, and I've made a few attempts at using the RANK method, but I can't seem to wrangle it into submission. Can anyone help?
See if the attached makes sense
Would you be able to share a sample where you attempted this?
See if the attached makes sense
I can show you the last thing I tried. but I can't share the actual data.
This is the last search string I tried for the action (Icreated a smaller data set with fewer columns and rows to play with):
=AGGR(IF(RANK(TestFailed)<=20, TestProvider),TestProvider)
How about this?
='=Rank(TestFailed) < 21'
Here I am assuming that your expression in the chart is TestFailed (with no aggregation like Sum or Avg)... Is that right?
That was it. Thanks.
Awesome