Forum Discussion
How to Pick value From column which has highest sales based on Rank
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:
Super UserYou 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.