You can use the concept of row level security
It would be great if you attach a sample workbook so that will see if its possible to do with calculations itself
Naveen, that was quick. Really appreciate you taking time and helping me out.
Just want to point out the fact that row level security is achieved by quick filter on "Award Level" (May be you could correct me here). When I select bronze in the single drop-down award level quick filter the dashboard will filter to bronze data. Likewise for silver, gold and platinum. The question is how do I control the default view?
Let's say this: Naveen just started his career and so he should see bronze data by default until 10 days. After 10 days default view should change to silver upto 30 days. Once Naveen reaches 31st day he should see gold by default. And always, Naveen will have a quick filter to navigate to other award levels.
I'm trying to think of a similar example, build data and then a dashboard for your better reference.
PS: Instead of direct quick filter, I can create a parameter with 5 values. 1 - 4 are for the award levels and will leave the 5th blank (default value for parameter). Whenever it's blank, we can calculate for current award level and filter the data. Easier said than implemented for me.
Thank you once again!