After successfully installing the OWOX: Reports, Charts & Pivots extension, you can proceed to create a new report by following the steps below.
Step 1. Open the 'Extensions' menu in the Google Sheets toolbar. Locate the 'OWOX: Reports, Charts & Pivots (Sheets, BigQuery)' item, then select 'Add a new report'.
Note:Each new report is created in a new sheet.
Step 2. The extension interface is opened. Now select the Project from the list of projects you can access.
ImportantThis list showcases GCP projects accessible to your Google account, which was used during the installation of the Extension. Selecting a GCP project and running a Data Mart in the Extension automatically creates an OWOX BI project if none is already associated with that GCP project. Read more in this article
Step 3. If you don't have any existing Data Marts, follow this instruction to create the first one. Otherwise, select one of the existing Data Marts from the list.
Step 4. Click the 'Run' button to load your data from BigQuery to the Spreadsheet.
Step 5. (Optional). Add some Filters, Limits, and Sorting to your Report.
Step 6 (Optional). Create automated charts and pivot tables in two simple clicks.
You're all set! Wait while the data is loaded into your Spreadsheet.
What's next? You might be interested in:
- How to schedule automatic data refreshes in your report
- Where to monitor monthly Report Run consumption
0 Comments