Hi,
I have a requirement to show top 2 and bottom 2 markets in a single bar chart and both should be shown in different colours. I tried to implement this using rank function and conditional expressions but i am facing issues when the markets have same values and the top and bottom values are same.
1.) Is it a good idea to shown the top and bottom markets in a single chart? If no, do we have any alternatives.
2.) How can we resolve this issue if i go ahead with the current implementation.
Ex:
There are four expressions in my chart and 'Market' as a dimension.
- First expression checks if the possible count of market is >3 and the ranks the markets and displays only those whose rank is <=2
- Second expression checks if the possible count of market is >3 and the ranks the markets based on descending order and displays only those whose rank is <=2
- Third checks if the possible count is >1 and <4 and ranks and displays only top value
- Fourth checks if the possible count is >1 and <4 and ranks (des order) and displays only top value
