Sprinkle Docs
Search…
πŸ“ˆ
Data Visualization
Walkthrough of various visualization charts, advance options 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 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.

Jumpstart
⚑
​

​
1
Read about the visualization charts
πŸ“Š
​
πŸ“ˆ
​
πŸ“‰
​
πŸ’Ή
that are available in Sprinkle,
πŸ–±
click here​
​
2
To know about the advanced options
πŸ› 
like Pivot, Aggregates, Transpose,
πŸ–±
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.
πŸŽ‰
​
✨
​

Visualization Charts

Line Graph
πŸ“‰
​

From the chart section,
πŸ–±
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
πŸ“Š
​

​
πŸ–±
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

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, 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, 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 are 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, 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, trips format are supported.
In the below
πŸ”½
example, 406 Indian cities are plotted according to their latitude and longitude data.
Geo Map: Cities

Download Charts

Sprinkle also has a feature to download all these visualizations charts as PDF from Segments and Explores. Just click on Download as Pdf button in Chart option and it will download the visualization chart.

Advanced Options

The advanced options
βš™
are available for the Segments in the Charts Section.

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, analyse data in terms of various dimensions.
To use the pivot chart option, open the Segment report, in the section of charts,
πŸ–±
click on the settings
βš™
icon.
Pivot on a column and convert data from row-level to column level. Select the column to be pivoted from the drop-down. According to the measure selected new columns will get created by converting row-level data to the column level.
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

Cumulative Sum & Percentages

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 to the settings modal form, as below
πŸ”½
.
Settings Modal: Aggregates & Value Format
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). In the below
πŸ”½
example, the value(per cent) has been selected.
Table Output

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 settings
βš™
icon and update the "Transpose On" field.
Settings Modal Form: Transpose Data
In the same example as above, the data is transposed based on the Product Line. The transposed output is shown below, where we have the product lines as columns & Shipped Months in the rows.
Transposed Data based on Product Line

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.

Fixed 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 Settings in the segment View and can select the columns in the Fixed Columns field. 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.

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.
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 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, 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.

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 in the y-axis. And the individual contribution for Cars, Motorcycles, Planes, Ships, Trains to the Total Sales is plotted with the help of stacked chart option.