Sprinkle Docs
Search…
πŸ“ˆ
Data Visualization
Walkthrough of various visualization charts, and advanced options in table view like Pivot, Aggregates & Transpose. Along with various options to customize charts.
Building visualizations using your data is super easy & intuitive on Sprinkle. Choose from an exhaustive list of visualizations on Sprinkle and present your data in a more interesting & engaging way.
πŸŽ‰
​
Through the left navigation panel,
πŸ–±
click on the Segments or Explores Section on the Sprinkle to use the visualization features.
These are available in the Charts section on your Segments or Explores Page.
You can select between the Table and the Chart view. While the Table view gives you the tabular data in terms of columns and rows, the Charts View has rich Visualization. The Table and Chart views are discussed below in detail.
​

Jumpstart
⚑
​

​
1
Read about the visualization charts
πŸ“Š
​
πŸ“ˆ
​
πŸ“‰
​
πŸ’Ή
that are available in Sprinkle,
πŸ–±
click here​
​
2
To know about the advanced options
πŸ› 
like Pivot, Transpose, Aggregates, and Freeze Columns in Table View
πŸ–±
click here​
​
3
Understand the visualization settings
βš™
to add various chart elements,
πŸ–±
click here​
Read on
πŸ€“
to gain complete insight into creating various visualization available on Sprinkle.
πŸŽ‰
​
✨
​

Charts View

The chart view has rich visualization graph options that empower you to present the tabular data into interactive graphs. Let us go through these graphs one by one.

Line Graph
πŸ“‰
​

In the Charts View,
πŸ–±
click on the Line Graph Icon. Select the X & Y-Series on the right, to be displayed on the graph. Through the Labels tab, add the x & y-axis labels. From the Colours Tab, assign customized colours to the graph.
πŸ–±
Click on Plot, to plot the graph.
The below
πŸ”½
example displays the trends in the number of successful & cancelled orders against the order months timeline.
Line Graph: Successful/Cancelled Orders vs Order Month

Column Graph
πŸ“Š
​

In the Charts View,
πŸ–±
Click on the Column Graph Icon. Select the X & Y-Series on the right, to be displayed on the graph. The below
πŸ”½
example displays the columns, Y-series, successful & cancelled orders plotted against the product lines.
Column Graph: Successful/Cancelled Orders vs Product Line

Bar Graph

In the Charts View,
πŸ–±
Click on the Bar Graph Icon. Bar Graph can be created in a similar way as the column graph, by selecting the X & Y-Series on the right, and plotting it. The below
πŸ”½
example displays the Bars, Y-series, and successful & cancelled orders plotted against the product lines.
Bar Graph: Product Line vs Successful/Cancelled Orders

Combo Graph

The Combo graph lets you combine two or more graphs and display them on the same chart. In the below
πŸ”½
example, the Total Cancelled Order is displayed as a line graph, with a y-axis on left. while the Total Successful Orders are displayed as a bar graph, with the y-axis on the right.
Combo Graph: Cancelled Orders - Line Graph & Successful Orders - Bar Graph

Scatter Plot

​
πŸ–±
Click on the Scatter Plot Icon. Select the X & Y-Series on the right, to be displayed on the graph. In the below
πŸ”½
example scatter plot is plotted between the Average quantity ordered and the number of days it takes to deliver the order, to see if there is any relationship between the two.
Scatter Plot: Avg Quantity Ordered vs Delivered In Days

Pie Chart

​
πŸ–±
Click on the Pie-chart Icon, to plot a Pie-Chart. Select the SIice Labels according to the dimension, and select the Slice Values, which are the measure that is to be displayed.
In the below
πŸ”½
example, the Total Cancelled Order is displayed for different product lines. We can observe that the Classic Cars have the highest percentage of Cancelled Orders.
Pie Chart: Total Cancelled Orders vs Product Lines

Bubble Graph

A Bubble Chart is a multi-variable graph that is a cross between a Scatterplot and a Proportional Area Chart. It contains information in the two axes, also the size & colour of the circles can represent some value.
​
πŸ–±
Click on the Bubble Graph Icon. Select the value to be represented on the x and y-axis. Select the measure/numerical dimension to represent the colour and size of the circles plotted.
In the below
πŸ”½
example, the Total Quantity Ordered is displayed on the x-axis. On the y-axis, the Total number of Orders is represented. The colour indicates the number of days taken for the delivery, ranging from 1 to 8.
Bubble Graph

Histogram

A histogram is a bar graph-like representation of data that buckets a range of outcomes into columns along the x-axis. The y-axis represents the number count or percentage of occurrences in the data for each column and can be used to visualize data distributions.
​
πŸ–±
Click on the Histogram Plot Icon. Select the Y-Series on the right.
In the below
πŸ”½
example, the number of orders is bucketed based on the buckets in terms of delivery in days.
Histogram Distribution of Orders in terms of delivered in number of days

Funnel

A funnel chart helps you visualize a process like online shopping that has sequential stages, like, search, view product, add to cart, payment, and purchase.
​
πŸ–±
Click on the Funnel Plot Icon. Select the value & per cent relative to, in the right form.
In the below
πŸ”½
example, the number of users across each stage in the online-purchase transaction is represented.
Funnel Graph: Online Shopping Process

Geo

Sprinkle also has Geo Charts to enable you to plot your geographical data.
πŸ–±
Click on Geo Plot Icon to get started. Various types like points, arc, Line, Cluster, Hexabin, Polygon, Cluster, Icon, Heatmap, H3, 3D, and trips format are supported.
In the below
πŸ”½
example, 406 Indian cities are plotted according to their latitude and longitude data.
Geo Map: Cities

Download Table/Charts

Sprinkle also has a feature to download all these visualization charts as PDFs from Segments and Explores.
Also, the tables can be downloaded as CSV.
Just click on the dropdown Download button, and chose to download it as CSV or PDF and it will download the table and chart respectively.

Table View

The Table view has advanced features like Pivot, Transpose, Aggregates & Freeze Columns. These features enable you to create advanced reports while working with the tabular data.

Pivot β†Ί

Pivot lets you quickly analyse & summarize data in the way you want, which enables you to answer various questions
πŸ€”
with the help of data.
Sprinkle's Pivot Option in the Segment report helps you dig deeper into your data, and analyse data in terms of various dimensions.
To use the pivot chart option, open the Segment report, go to the Results section, and
πŸ–±
click on the Pivot icon.
In the Pivot Modal: Select the column to be pivoted on from the drop-down. According to the measures selected new columns will get created.
In the below example, the Orders report is pivoted on the Shipped Month Column. The aggregates selected are the column & row sum. The Product Line column has been fixed, in order to enable the user to see the total orders data corresponding to the product lines easily.
On
πŸ–±
clicking Ok, the required pivot is generated based on the shipped month column.
Pivot Output

Other Features in Pivot

​
1
Column Grouping

The pivoted columns can be grouped together in the UI.
The pivoted columns that are based on Date dimensions can be grouped together based on Quarterly, Half-Yearly, and Yearly basis.
If you want to group columns of other types, then define it in hierarchies. For example, you define the hierachies as city that rolls to state. The pivoted columns pertaining to say Revenue of Each of the cities can be grouped together in the UI into States.

Subtotal

Sub-Total enables you to get the total across each distinct category in the dimensions.
​
πŸ–±
Click on the Pivot Icon, Select the Column to Pivot On, and then select the column to whcih the sub-total is to be applied.
In the
⬇
below example, we have pivoted the data on Product Line, and have enabled sub-total for Status. Thus, Subtotals for Cancelled and Disputed can be viewed.

Transpose

Transpose is the process of swapping rows into columns and vice versa. This can be performed on some particular column or row as per your preferences. This gives a varied three-dimensional view of the records.
To transpose,
πŸ–±
click on the Transpose icon and update the "Transpose On" field.

Aggregates

In the same example as above, the Row Sum & Column Sum has been enabled to provide the row-level & column level sum of total orders, along the shipped month. The same was achieved by adding the aggregates fields as below
πŸ”½
.
πŸ–±
Click on the Aggregates Icon and select the Aggregation type and then the measure on which the aggregation is to be applied.
The format of the values in the columns can be customized as needed. The available options are, the entries denoted as values, per cent & value(per cent).

Freeze Columns

At times when the number of columns is large or there are many measures across a dimension and we want to fix a dimension (column) to view values corresponding to it. It is when the Fixed Columns feature option comes in handy.
Using this feature, select the columns which need to be static. Click on Freeze Column Icon in the Table view and select the columns to be frozen. In the below report, data is pivoted on the β€œShipped Date Month” column and the β€œProduct Line” column is fixed, to enable viewing the monthly data which are in the following columns.
The β€œProduct Line” column is fixed and other columns are movable. Now you can easily view and check the measure values for corresponding dimensions. In a similar way, multiple dimension columns can be fixed as well.

Visualization Settings

Show Label Annotations on Charts

Plot any kind of chart and enable Show Labels Annotations, to show the labels on the plotted chart.
In the below
πŸ”½
column chart Total GMV is plotted against each product line. Now you can enable Label Annotations and see the Total GMV value on the top of each bar.
To save the changes,
πŸ–±
click on Plot and then click on Save to save the changes.

Other Tooltips

To see other legends on the plotted chart when the user's mouse hovers on a particular point or on a particular bar then the user needs to select those legends in the Other tooltips.
You can also see other data in form of legends by hovering over the graph. To enable data to be displayed as a tooltip, select the measure in the Other Tooltips.
The below
πŸ”½
column chart hovering over a column by default shows the legends of Product Line (x-axis) and Total successful GMV (y-axis). By selecting other dimensions and measures in Other Tooltips you can see other Legends as well. In the below chart β€œTotal Cancelled GMV” & "Total Orders" are selected in other tooltips.
To save the changes,
πŸ–±
click on Plot and then click on Save to save the changes.
Other Tooltips

Benchmark Coloring Color By Dimension

After putting the Benchmark line into the chart, you can also colour the bars based on the benchmark line.
πŸ–±
Click on the Colors tab, and check the Show Colors on the basis of Benchmark? option, select the colours for Above Benchmark and Below Benchmark values from the colour palette and click on Plot.
Benchmark Coloring

Charts with Benchmark Lines

During an analysis using visualizations, a benchmark line for the charts is very useful. These benchmark lines can be drawn at the average point, and also given an option to set this value on any predefined point/value which is given by the user.
Average Value: When selecting the Average option in the Benchmark section, the average value of the data is calculated and acc. to that value a benchmark line is drawn on the graph.
Benchmark Line: Average Value
User Given Value: When the user gives the benchmark value, then the benchmark line is drawn on the graph as per the user-specified value.
Benchmark Line: Constant Value

Stacked Charts

Stacked charts are charts where users can view the whole, parts of the whole, and part-to-whole comparisons. It helps to view numeric values across one categorical variable to two.
In the below example, On the X-axis shipped month, the total sales values are plotted on the y-axis. And the individual contribution of Cars, Motorcycles, Planes, Ships, and Trains to the Total Sales is plotted with the help of the stacked chart option.
Stacked Charts
Copy link
On this page
Jumpstart
Charts View
Download Table/Charts
Table View
Pivot β†Ί
Transpose
Aggregates
Freeze Columns
Visualization Settings
Show Label Annotations on Charts
Other Tooltips
Benchmark Coloring Color By Dimension
Charts with Benchmark Lines
Stacked Charts