The table contains million of lines. The goal is to only show the top N records, with the table sorted on score descending. Please note that the score column contains not only distinct values. Say that 500 records have the highest score of 5 and i want to show top 100, then it should show random 100 from those 500.
i would be able to have this result using the following query:
select top 100 * from table order by Score descending. However, i would preferably not create another table for this table chart and limit the results using dimension expressions.
I have tried using dimension limits... i select both largest or first 10 values, but i does not show top 10 records. I think this option would work i have had scores from e.g. 1 to 100 and no duplicate scores exist.
Dimension limits should work but you need to make sure you set your sort options correctly. If you only want to order by Score and everything else to be random you need to remove the sort from all other fields. Please see the example.
Thanks for the replies. I more or less understood already that the problem was the there are no distinct values in the score column. However, none of my columns have distinct values.. only the combination of year, company code, document and line item makes the row unique. How can i include this?