Whenever you’ve arrived at an answer that you want to save for later, click the SAVE button in the top right of the screen. This will also save the visualization option you’ve chosen for your answer.
A pop-up box will appear, prompting you to give your question a name and description, and to pick which collection to save it in. Note that your administrator might have set things up so that you’re only allowed to save questions in certain collections, but you can always save things in your Personal Collection. After saving your question, you’ll be asked if you want to add it to a new or existing dashboard.
Now, whenever you want to refer to your question again you can find it by searching for it in the search bar at the top of Metabase, or by navigating to the collection where you saved it. To edit your question, go to it and click the pencil icon in the top-right.
If your Metabase administrator has enabled public sharing on a saved question or dashboard, you can go to that question or dashboard and click on the sharing icon to find its public links. Public links can be viewed by anyone, even if they don’t have access to Metabase. You can also use the public embedding code to embed your question or dashboard in a simple web page or blog post.
After your team has been using Metabase for a while, you’ll probably end up with lots of saved questions. Metabase has several ways to help you organize things and find what you’re looking for.
Collections are the main way to organize questions, as well as dashboards and pulses. Administrators can give you different kinds of access to each collection:
In addition to the collections you and your teammates have made, you’ll also always have your own personal collection that only you and administrators can see. To find it, click on the “browse all items” button on the homepage and click on “my personal collection” in the list of collections.
You can use your personal collection as a scratch space to put experiments and explorations that you don’t think would be particularly interesting to the rest of your team, or as a work-in-progress space where you can work on things and then move them to a shared place once they’re ready.
In each collection, you can pin important or useful dashboards or questions to make them stick to the top of the screen. Pinned items will also be displayed as large cards to make them stand out well. If you have Curate permissions for a collection, you can pin and un-pin things, and drag and drop pins to change their order.
Any dashboards that are pinned in the main “Our analytics” collection will also show up on the homepage.
Use the search bar to find dashboards, questions, collections, and pulses. You can select from the typeahead’s dropdown results, or hit enter to view a search results page. You can also activate the search bar from anywhere by pressing the
Searches take into account items’ titles, descriptions, and other metadata — you can even search the contents of your SQL queries. For example, you can search for things like
SELECT escape_pod FROM mothership and find that one question you worked on six months ago. The results will display an item’s description, which collection it’s saved in, what kind of object it is, and whether it’s pinned. Note that you’ll only ever see items in collections you have permission to view.
To move a question, dashboard, or pulse into a collection, or from one collection to another, just click and drag it onto the collection where you want it to go. You can also click on the
… menu to the right of the question and pick the Move action. If you’re trying to move several things at once, click on the items’ icons to select them, then click the Move action that pops up at the bottom of the screen.
Note that you have to have Curate permission for the collection that you’re moving a question into and the collection you’re moving the question out of.
Sometimes questions outlive their usefulness and need to be sent to Question Heaven. To archive a question or dashboard, just click on the
… menu that appears on the far right when you hover over a question and pick the Archive action. You’ll only see that option if you have “curate” permission for the current collection. You can also archive multiple items at once, the same way as you move multiple items. Note that archiving a question removes it from all dashboards or Pulses where it appears, so be careful!
You can also archive collections if you have curate permissions for the collection you’re trying to archive, the collection it’s inside of, as well as any and all collections inside of it. Archiving a collection archives all of its contents as well.
If you have second thoughts and want to bring an archived item back, you can see all your archived questions from the archive; click the menu icon in the top-right of any collection page to get to the archive. To unarchive a question, hover over it and click the unarchive icon that appears on the far right.
Next, we’ll learn about creating dashboards and adding questions to them.