Forum Discussion
TOP N not working
Hello cham
I believe I did find a way to solve this. I had to add a drivers table to use as a anchor for the rankings.
The udpated file is attached.
You can apply a filter to a visual of TopN based on a measure. For ranking you want to do it in BottomN so it will go from lowets (1, which is the best rank) up.
Not sure what you mean about country, can you share your data including the country and show the problem and expected result?
Hi jdbuchanan71 ,
https://drive.google.com/file/d/10a5XQYojfl9c-4unh1ZBbmDNs9E2ekh5/view?usp=sharing
Please find the above link to access the file. I want to show Top 20 "N" value accoding to the drive and the country.
I am confusing why you create a response count aand ave score for this? I want to get top 20 drivers in countries which show top 20 "N values"
Hope this explain you my question.
Hello cham
I believe I did find a way to solve this. I had to add a drivers table to use as a anchor for the rankings.
The udpated file is attached.
Hi jdbuchanan71
I have added a resposes field that now you can filter it. Please check the updated file.