We have just started doing this in our instance. We have Staging and Production (among other) environments of our application, so to report out of either environment we needed to be able to do this. There may be more efficient ways to do this, but this is how we’ve accomplished it.
First, we created new explores for the Staging environment. We just “included” the existing explores that are pointing at production and changed the data source, so that the Staging and other explores inherit all the same modeling as the Production explores. (This assumes the underlying database schema for both data sources is the same - in our case, they are).
Then, from each tile on the dashboard you’re trying to convert, click the ‘explore from here’ link.
In the new tab that is opened, you can change the model in the URL to the correct model and resubmit the URL. This will construct the same query using the other explore.
Then, from the cogwheel “Save to Dashboard” and select your new dashboard.
From there, you just have to reorganize the tiles on the dashboard to their appropriate positions and you’re done.
It is still creating each tile 1 by 1, but you don’t have to go through the work of picking fields, adding table calculations, changing visualization options, etc, because that will all be captured in the “Explore from Here” URL.
We converted 13 dashboards, each with 15+ tiles, across environments this way and it only took an hour or so.
LinkedIn
Twitter
