I am working on a dashboard that gets refreshed 2 minutes. It has a time stamp field apart from other dimensions.
One of my sheet contains line charts, bar charts with fields and dimensions showing data of last 60 minutes only. I have used if condition in the script to create a field which tells if the record lies in last 60 minutes and then used set analysis to control the charts on this sheet.
Now, I want is a dropdown on sheet with the following values: 1) Last 5 minutes
2) Last 10 minutes
3) Last 30 minutes.
So that the charts on the sheet display data of last X minutes only. Please guide as I don't want to create multiple sheets (one for last 10 minutes, one for last 30 minutes) with the same visualizations but data constrained by set analysis accordingly.
In other words, how can I use 1 set analysis condition that helps me control data of the selected time (say last minute)