(Previously Segments) An overview of the Reports on Sprinkle, with a walkthrough on how to use it to generate your reports.
Reports give you the capability to build detailed reports that provide a deep analysis based on various dimensions and measures.
Reports : Explanation & Feature Walkthrough
A Model is needed to create Reports. By choosing dimensions and measures on your model, Reports can be created. Dimensions are used to bucket or group the measures example by country, city, or region.
There can be multiple dimensions in a model, for example, total sales by a country, top 10 users by the sum of sales, etc. Here total sale is a measure, the country is a dimension. By choosing the country as the dimension see the total sales by a country. Thus, multiple Reports can be created from a model.
generate detailed reports with explicit visualizations from the existing model, with little effort
Through the left navigation pane,
click on Analyze and then
Click on Reports to use the feature.
On the Reports page, there are two tabs, My Reports & Shared With Me.
Click on New to create a new report.
Reports Home Page
On successful creation of the new report, the Edit page comes up.
The Edit Page is made of 5 sections:
Edit Reports UI Sections
From this section, you can select the Model from which the report is to be made. The models can be searched & selected from the available models in the warehouse.
The Dimensions & Measures that were created during the Model creation is visible in this section under the tabs.
Dimensions are Qualitative data like names, dates, geographical locations, etc. which are used to categorize or Segment your data.
Measures are Quantitative data like Amounts, Averages, Count, Prices, quantity, etc. Measures can be aggregated and used to derive other measures.
The Filter option, lets you filter the data as per the reporting requirements. The options available to filter the data is shown below. Advance filter logic can be built using the Add Condition & Add Group Options on the right.
The Measure filter is used to filter our data for the report based on the Measures, the aggregate quantitative values.
Measure Filter Options
You can also sort the output data based on any of the columns, in an ascending or descending order.
The Save and Run button on the right saves the report options and produces the output in the chart section. The Job section shows the last three jobs that were run and related information.
Save & Run Button
Click on Show Details to view the details of the Job & the SQL query that was run in the background to produce the required output.
On Saving & Running the Job, the result is shown in the Results section.
The result section has two views, The Table View and the Chart View.
The output of your query across dimensions and measures is shown in tabular form. The Table view provides you with other advanced features like Pivot, Transpose, Aggregates & Freeze Columns. Read more about these here.
On the Chart view, you can select from an exhaustive list of visualizations like Line, Column, Bar, Combo, Scatter, Pie, Bubble, Histogram, Funnel, Map, Geo, Stat to aptly present the data in the report. To Know in detail about the visualization options, refer here.
- Auto-Run: Set Auto-Run, to run the Report periodically and update the results automatically
- Email: Set for EmailNotification when the Report is Set to Auto-Run, by defining the Trigger, Notification Type, To & Subject of the Email📩
- Settings: Control the General, Drilldown & Embed Settings through the Settings Option
Drilldown enables to drill down into the details of the reports without the need to create separate reports
Embed Report enables users to visualise the Sprinkle Reports in any other third-party tools or platform
- Share: Reports can be shared with users and user groups like Admin, Developer, Analyst, Report Viewer
- Clone: Reports can be Cloned (or Copied) and used to build over the top of existing Reports.
- Delete: To Delete the particular Report
- View Activity: User activity on Reports can be viewed using this option
Three Dots: More Options on the Edit Page
clicking the View Button on the top right, the result can be viewed full page, and visualization can be applied from the list of 12 available visualization options.
Click on the three dots on the right to reveal the Add to Dashboard Option. The Report can directly be added to the existing Dashboard.
Through the Download 📥 Icon on the right, the report can be downloaded in CSV format.
Add to Dashboard & Download CSV
The Report owner or other users with access can add Tags to the Reports. Go through the detailed documentation on Tags.