Forum Discussion
How to Pick value From column which has highest sales based on Rank
Hello All,
I am trying this below approch but not able to move forward, Anyone help.
I Have a column called Hour , measure called ATM total for these i have created Rank .
Now I need to pick which hour has highest ATM Total value. or Pick Hour where Rank = 1
Output has to be desplayed in card (scalar value) = 11
You can add the card visual to your canvas and put the Hour in it (set aggregation to min, max, or average), then in filters on this visual drag Hour over, choose Top N and set it to 1, then you can add the Total ATM measure in and it should display 11 in the case.
Here is the data I entered to show how to do it:
3 Replies
- audreygerred
Super User
You can add the card visual to your canvas and put the Hour in it (set aggregation to min, max, or average), then in filters on this visual drag Hour over, choose Top N and set it to 1, then you can add the Total ATM measure in and it should display 11 in the case.
Here is the data I entered to show how to do it:
Thank you!! its worked. I tried this approcah before but i kept hour one time in filter that didn't allow me to select Top N. but keeping hour double time in filter enable the Top N.
Thank you so much! audreygerred- audreygerred
You are very welcome! You can also hide any filters you don't want report users to be able to see.
