I need top 5 of each chart. Is there a way to do same?
1 Like
@David_Wong
Thanks for reply.
This Top bottom filter gives you Top 5 Orders overall.
But I would like to have top 5 in each category(Industry as per your screenshot).
Can you help me with that?
Hi @rsingh4
what exactly do you mean by the “top 5 in each category”? The 5 MONTHS with the highest number of distinct orders? In that case only five bars per industry will be displayed.
GL
1 Like
Hi @gillepa
Apologies for confusion. We have build a small multiple bar chart to track instance cost in each environment.
Currently it has top 50 instance cost in the above image.
I am looking for a way to just display Top 5 spending instance in each environment using this small multiple bar chart?
Hi @rsingh4
I believe there is a way but you need to use a rank function and filter on it.
If you start with a setup like this
where you have Instances on the X axis, and Environment in the Small Multiples with Cost in Values, create a calculated field “Ranking Instances” that ranks sum(Cost) by Environment:
I’m assuming that there is no need for an aggregation for the cost per instance; one instance per row, and one associated cost.
Then add this new field as a filter in the visual like this:
It will show the top 5 instances per cost in each environment.
I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
Hope this helps,
GL
2 Likes