Question
I want to edit an existing query in Explore without losing the original one. Is it possible to make a copy of the original query?
Answer
Instead of creating an entirely new query from scratch, you can clone existing queries and then modify this duplicate.
To clone a query
- Open the Explore dashboard.
- Select the Queries (
) option from the left panel menu. - Find the query you want to duplicate in the list shown, or search for it in the search bar.
- Hover over the query name, and click the three dots that appear on the right of the list.
- Select Clone.
- Rename the duplicated query so you can distinguish between it and the original, and hit OK.
Your new duplicated query will now appear in the list and you can customize it as needed.
Note: Make sure to choose a dataset of the same type otherwise the missing metrics and attributes won't work in the newly cloned query (see [Video] Why do I get an error cloning my query into a new dataset?).
7 Comments
Is there a way to do this from the query builder itself, rather than cloning it from the query list?
Hey Alexis,
If you select the drop-down icon next to the Save button within the query you should see the option to clone.
Hope this helps!
Hi Brett,
If I select the drop-down icon next the save button within the query, I get the options Save, Add to Dashboard, Save as New and Export. Clicking Save on New creates a copy of the query immediately, with no way to rename it until you enter into each separately query separately after it's creation, and the the only way to distinguish between them being the timestamp.
I see this causing confusion down the track for some users.
Hey Janaya,
Thanks for taking the time to share this with us! I can see how this can be a bit confusing so I'll be sure to pass this feedback along to our Product Managers!
Hi Brett,
You're welcome! Sounds good.
Have a great day
Our business uses the same reports across multiple customers with subtle differences like organization ID etc. There should be a way to mass clone queries we have already built without having to to them one by one. So long as we are cloning them to the same dataset, I fail to see why this isn't a feature.
Hello Pavel Grozev
So natively, this is not possible in Explore. I would recommend posting your use can in the Product feedback forums so our developers can consider implementing this in a future update. Let us know if there is anything else we can assist with. I'll also be sure to add this to our weekly digest in case the community knows of a workaround.
Best regards.
Please sign in to leave a comment.