It will then display the Save button, at which point you should choose save as New Question, give it a name, paste in the description you saved earlier and choose the location you want to save it into:
Next, make your change to the report (it will detect if a change has been made, so you need to make some sort of modification, even adding a space to SQL for this part). Then, click the pencil icon and select “Edit this question”, and copy the desription (for later use). First find the report and click on the report to open it. Q: Can I make tweaks to an existing report, or save it with all my filters already defined?Ī: Yes. To sort, you’ll need to edit the SQL itself and change the ORDER BY clause. Q: Why can’t I sort the columns on certain reports?Ī: Reports created using SQL can’t be sorted in the usual manner by clicking on the column header and sorting. Then save your question either in your own personal collection (if you do not wish for others to use it), or in the implementer collection (if you’d like others to be able to use it). Then, paste your SQL (format if you wish), and run. Then, log into metabase and click either Ask a Question -> Native Query, or click the “Write SQL” shortcut in the top right next to Settings. Q: How do I migrate a query from BARRT?Ī: Bring up your query in BARRT, and copy the SQL for that question. The custom Question option will let you apply filters before the results are displayed. For this reason, we don’t recommend using the Simple Question option. Q: Why is the simple question option so slow?Ī: A simple question brings back the entire national dataset of the selected table before you are able to filter the results, therefore it can be quite a lot of data being returned. Edge and IE are known to have some issues with the query builder. Q: What browsers work best with metabase?Ī: Metabase works best with Chrome, Firefox, and Safari.
From v6 Home page, go to Documentation -> DED. General Q: Where can I find the definitions of the data that is available in metabase?Ī: The RCARInfo Data Element Dictionary. 3.3 Q: I got an error ORA-00904 when configuring my variables, help!.3.2 Q: How do I create variables in my SQL questions?.3.1 Q: Is it possible to use visualizations on a native SQL query?.2.3 Q: Why can’t anyone else see my question or dashboard?.2.2 Q: Is it possible to share the results or visualizations with persons outside of metabase?.1.13 Q: How do I configure a question to email me the results?.1.12 Q: I used the correct password, but the system won’t let me log in.
1.10 Q: Can I see the count of the total number of results even if they are greater than 2000 rows?.1.8 Q: Is it possible to join data from different tables without using SQL?.1.7 Q: How do I un-select multiple columns from the query output?.1.6 Q: Can I make tweaks to an existing report, or save it with all my filters already defined?.1.5 Q: Why can’t I sort the columns on certain reports?.1.4 Q: How do I migrate a query from BARRT?.1.3 Q: Why is the simple question option so slow?.1.2 Q: What browsers work best with metabase?.1.1 Q: Where can I find the definitions of the data that is available in metabase?.
0 kommentar(er)
