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
After creating the model all the attributes present in the flow table will be listed. Sprinkle by default chooses the
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.