Forum Discussion
TOP 5 OR TOP 10 in a Measure Calculated Visual
Hi,
I have a measure which calculates a column called Call Rate
Anonymous
Have you tried using the filter pane to filter the Top N.
You should go to the field on filter pane where the Top N will be applied.
Then add the measure Call rate so as to filter the records by the value.
See image below:
5 Replies
Anonymous
Have you tried using the filter pane to filter the Top N.
You should go to the field on filter pane where the Top N will be applied.
Then add the measure Call rate so as to filter the records by the value.
See image below:
Hi,
You can use Topn filter in the filter pane on any categorical value. ( go to filter pane, select top n from the dropdown then use cell Rate measure and apply.
Refer:
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasadnvprasadand themistoklis - I do know that particular prodeure, but with a measure calculated value its not possible. The top option is not available.
The below is how it appears :
Anonymous
The filter must be applied on a categorical field not on call rate directly.
Call rate will be used to filter the data. In the image that I sent Order Qty was the categorical field and Call Rate was the measure.
So check the lowest granularity categorical field on table and filter it based on Call Rate
This video will help you
https://www.youtube.com/watch?v=veYjbBEgeQ8
