Create a Report

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'.

04.png

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.

01.png

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.

00012neww.png

 

Step 4. Click the 'Run' button to load your data from BigQuery to the Spreadsheet.

05.png

 

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:

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.