Here is one example.
Create parameter for top N (I just created 1 and 2 only)
Filter for respective worksheet
0 is for current
1 is for last hour
2 is for two hours before.
No display filter.
You can replace parameter of "Instead of current time" with now() in real environment.
Rank_example_SM_10.5.twbx 48.5 KB
Thank you for getting back. Sorry i'm using older version of Tableau (10.0) and cant open the file you have shared. Could you please share the screen shots of the calculation. It will be really helpful.
Really appreciate it. Will cross check and get back to you.
Thank you for your reply
What i'm looking for is, at the present hour who are the top N clients by tickets sold. Based on the present hour, i wanted to check the previous hour top N client by tickets sold.
So each time, i will check my current hour and wanted to display my previous hour's data.
Thanks & Regards,
Isn't it the same what I did? Please check your Initial description. For Present 11, you want to see only 9-10 and 7-8. Let me know, with Present 11 as Latest, what should be the time period for other two sheets. I can modify.