Forum Discussion
Solved
Filter by last X records
Hello,
I track the number of games that I play on a video game. While I know how to filter based on the last number of days - how do I filter a page based on the last 20 rows?
For example - I'm trying to find out my Win Percentage over the last 10 games.
HI TheAvatar,
You can try use topn function to get the result table, then use it create the visual.
Sample:
Result Table = TOPN(10,'Table',[Index Column],DESC)
last 10 records form calendar table
Reference:
Regards,
Xiaoxin Sheng
1 Reply
HI TheAvatar,
You can try use topn function to get the result table, then use it create the visual.
Sample:
Result Table = TOPN(10,'Table',[Index Column],DESC)
last 10 records form calendar table
Reference:
Regards,
Xiaoxin Sheng