Models

Creating Model

To create a model click on New. Give a name to the model and select the flow table or the DB ingested table and click on Next.

         

After creating the model all the attributes present in the flow table will be listed. Sprinkle by default chooses the dimensions, measures and date dimensions. The user can choose dimensions by just clicking in the checkbox.

         

The measure can be chosen by selecting the required aggregate function like percentile_90, Distinct, Percentile_50, Percentile_95, Average, Sum and Count. In this case average and sum is chosen for total line amount.

         

Date dimensions are the time span on which a report is built. Sprinkle supports hourly, daily, weekly, monthly, quarterly and yearly reports. The below screenshot shows the daily date dimensions. Click on the Create button to create the model.

         

The users can create a segment from the model page using Create Segment Report.

         

The user can also add customized dimensions and measures on the Expression tab in models. Calculated columns are created using expressions to obtain the desired answer, in this case the total sum of the line amount is created.

         

Model represents a multi-dimensional view on the table. This enables easy analysis, without the need to manually write SQL queries.