Sprinkle Docs
Search…
πŸ“Š
Dashboards
Creating & Editing Dashboards on Sprinkle & Feature Details

Overview

Business Intelligence Dashboard is a data visualization
πŸ“ˆ
​
πŸ’Ή
​
πŸ“‰
tool that displays the current status of metrics and key performance indicators (KPIs) for an enterprise.
Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department.
The essential features of a dashboard product include a customizable interface and the ability to pull real-time data from multiple sources.
Dashboards on Sprinkle can be created by combining reports or visualizations from different Explore and Segments.

Feature Walkthrough
🚢
​

Creating Dashboard

​
πŸ–±
Click on Analytics -> Dashboards on the left navigation pane, to start using the Dashboard feature on Sprinkle. The listing page lists all the dashboards that have been created by you in the My Dashboards tab and other team members in the Shared with Me tab.
Dashboard Listing Page
​
πŸ–±
Click on New on the top right corner of the page to create a new dashboard. Provide a Name to the Dashboard and
πŸ–±
click Create.
Create a New Dashboard
​
✨
Now start Adding Explores & Segments Reports and Visualizations to the Dashboard by clicking on the "+" icon or by selecting Add report from the more options, Three Dots icon on the right. Other options in the more options list are explained in the More Options Sections Below
⬇
​
Add Segments & Explores, More Options

Filter Mapping: Filter data on your dashboard

Filter Mapping empowers you to filter data on your dashboard, on the go. Customize your dashboard with filter operators.
To start using the Filter Mapping,
πŸ–±
click on More Options -> Filter Mapping
​
πŸ–±
Click on New to create a new filter.
More Option -> Filter Mappings
Put a Name to the Filter & Select its type. Add Description in the field. Select the Column on which the Filter is to be applied. Click on Create
✨
​
Filter Creation
​
πŸ–±
Click on the existing filter to edit it. The Filter can also be Renamed, once created, just change the name in the Edit form, Simple!
πŸŽ‰
​

Restricting Operators

Enabling Restricted Operators lets you restrict the operators that can be used in the filter on the Dashboard. In the Below
πŸ”½
Example, The Product Id filter has been restricted to "is any" & "is equal to".
Restricting Operators for the Filter

Multiple Columns mapping to a single filter

You can select multiple columns of the same type under one filter.
In the example below
πŸ”½
, the reporting model has two state columns named β€œSeller_State” and β€œBuyer_State”. While mapping filters to the dashboard a common filter called β€œstate” was created by selecting these two states columns. The filter applies AND logic to the outputs, and the same values are passed for both columns.
Multiple Colum Mapping

On Dashboard Page

Dashboard Page
Save and Run
Save Changes & Run the Job to update the dashboard with updated data.
Switch to Tab/Grid
Switch between Grid & Tab Views
Switch To Tab: Tab View of the Dashboard
Edit Layout
πŸ–Š
​
Customize the view of your layout best suited to your needs, through the Edit Layout Option. Easily drag & drop, enlarge reports on the dashboard.
Download Charts
Sprinkle also has a feature to download the complete dashboard or the individual visualization charts as PDF. Just click on Download as PDF button on the dashboard page to download the complete dashboard.
In order to download the individual visualization reports from the dashboard, you can click
on any report and then click on Download as PDF button.
Metadata
The Dashboard owner or other users with the access can add Business Metadata to the Dashboard. Go through the detailed documentation on the Business Metadata.

Filters

From the Filter Section in the Dashboard, you can quickly filter data that is represented in the dashboard. Hover over the
β„Ή
icon to view the description of the filter.
Re-Order Filters using the option on the right, based on the requirement.
Apply values to the filters, Save and Run. Voila!
✨
​
πŸŽ‰
You have updated the data on the Dashboard.
Filter Section on Dashboard

Jobs Section

The Job section shows the last three jobs that were run and related information. Jobs are run when
πŸ–±
Clicking Save and Run or Run on the top right corner.
Jobs Section
​
πŸ–±
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.

More Options

  • Auto-Run: Set Auto-Run, to run the Dashboard periodically and update the results automatically
  • Add Report: Add more Explores & Segments to the Dashboard using Add Report
  • Clone Dashboard: Dashboards can be Cloned (or Copied) and used to build over the top of existing Dashboards.
  • Add Merge Settings: Merge reports on the Dashboard to display a consolidated report
  • Settings: Manage Folder, Owner, Concurrency, Merge Fetch Limit through the settings
  • Share: Dashboards can be shared with users and user groups like Admin, Developer, Analyst, Report Viewer
  • Schedule Emails: Schedule Email
    πŸ“©
    Notification when the Dashboard is Set to Auto-Run, by defining the Trigger, Notification Type, To & Subject of the Email
  • Filer Mapping: Explained Above
    ⬆
    ​
  • Delete Dashboard: To Delete the Dashboard
  • View Activity: User activity on the Dashboard can be viewed using this option
  • Embed URL: Embed Dashboard to third party applications using the Embed URL Feature
Copy link
On this page
Overview
Feature Walkthrough
Creating Dashboard
Filter Mapping: Filter data on your dashboard
On Dashboard Page
More Options