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 Chartssection on your Segments or Explores Page.
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.