Prove Enterprise - Creating reports + Adding/asking questions

Introduction

By asking questions, you are able to define the data/statistics that you would like to see in Prove Enterprise. 

This page covers how to ask a question using Prove Enterprise's graphical query builder, the “Question” option.

Creating a new question with the query builder

From the + New dropdown, select Question, then pick your starting data:

You can start a question from:

• A model. A model is a special kind of saved question meant to be used as a good starting point for questions. Sometimes these are called derived tables, as they usually pull together data from multiple raw tables.
• Raw data. You’ll need to specify the database and the table in that database as the starting point for your question.
• A saved question. You can use the results of any question as the starting point for a new question.

Note that there are some kinds of saved questions that can’t be used as source data:

• Druid questions
• Mongo questions
• Questions that use Cumulative Sum or Cumulative Count aggregations
• Questions that have columns that are named the same or similar thing, like Count and Count 2

The query builder

Once you select your data, Prove Enterprise will take you to the query builder. Say you selected Raw data > Sample database > Orders, then you’ll see something like this:

This is the query builder’s notebook editor. It has three default steps.

• Picking data
• Filtering
• Summarising and grouping by

To the right of each completed step is a Preview button (looks like a Play button - a triangle pointing to the right) that shows you the first 10 rows of the results of your question up to that step.

Picking data

The data section is where you select the data you want to work with. Here you’ll pick a model, a table from a database, or a saved question. You can click on a table to select which columns you want to include in your results.