Hi I have a requirement to report on the current data for a period and using a Dashboard makes a lot of sense except that since I have to analyse the data every week I need to redo the report each time I want to change
It would be great if I could create a variable (1 or more) that can be applied to the incoming smartsheet date for reports, graphs etc) so that when I change the variable (perhaps user changeable via a drop down box) the Dashboard would automatically have all the correct data as per that variable -
e.g.
MyVar1 = User1,User2,User3
MyVar2 = Qtr1,Qtr2,Qtr3
When the user select User2 and Qtr3 you would only see data from the reports that match that criteria and they you could select User1 and the data would change in the dashboard
thanks