Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a dashboard that needs to have mutiple copies based on changes to a set of dimensions like location and time.
E.g.
NewYork Sales Dashboard
Texas Sales Dashboard
SanFransicao Sales Dashboard.
Is there a way in which i can make a master dashboard and run a script or something to generate these new dashboards for all locations in a loop or something like that?
I do not think you can create full dashboard in a looop.
But you can can have multiple sheets within the same app with the same structure and limit with the Filter option (available in Saas) or create multiple app/Dashboards, run one main model and then within the Dashboards script you can narrow down the using where statment
With normal data it won't be necessary because the wanted sub-set could be chosen with a few selections. If the data are confidential in some way the use of a section access may be more suitable.