SlicingDice Documentation

SlicingDice - The All-in-One Solution Documentation

Welcome to the SlicingDice documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

3. Creating a Chart

On this page we explain how to add a new chart on the Data Visualization module using the Control Panel.


Creating a chart using the control panel

Watch this quick video below to learn step-by-step how to add a data chart using the Control Panel.

Working with measures, dimensions and calculations

Watch this quick video below to learn step-by-step how to add measures, dimension and calculations to your charts.


Creating a chart step-by-step

Step 1 - Open the Chart designer

There are several ways to get to the charts designer:

  • From the Dashboards page, click the plus button in the bottom right corner. Select Blank. From the Dashboard editor, choose INSERT button and click Chart.
  • From the Saved charts page, click the plus button in the bottom right corner.
  • From the Presentations page, click the plus button in the bottom right corner. From the Presentation editor, choose INSERT button and click Chart (please note that Presentations are available starting from the Small Business plan).

NOTE: Dashboards are groups of charts, text and media content. To read more about creating dashboards, go here. To read more about creating presentations, go here.

Step 2 - Choose a data source

Next, you will have to select where your data is coming from.

Select the database or dataset you want to use to create your chart.

Step 3 - Choose a chart type

Once you chose the data source, you’ll see the Choose a chart type dialog window. Be sure to explore all the different chart types to choose the one that displays the data clearly.

Step 4 - Working with measures and dimensions

Then, add a dimension for the Category axis. To understand what is going on, you should first understand the difference between measures and dimensions.

MEASURES are numbers, or quantitative values. For example, #of orders, #of users, Profit, Price, #of days and so on. Measures are marked with ‘#’ symbol.

DIMENSIONS are categories by which you group your measures, for example country, product category or employee. Dimensions are marked with Abc(string icon), clock icon(clock icon) or map point(geo icon) icon.

Decide which measure you wish to focus on for the chart, and then select the appropriate aggregation type for your measure (for example, sums for total sales or averages for a percentage).

Done. Your chart will appear on the screen.

The following steps are optional. You can add filters, sorting, or customize the chart (to do this, select the appropriate step from the top ribbon).

When the chart is ready, just click DONE at the top right corner of the Chart editor. The chart will be added to a dashboard/saved charts/presentation (depending on the way you start the chart creation). You can always get back to chart editing by selecting the chart and clicking Edit chart from the gear wheel menu.

Step 5 - Add filters (optional)

Filters are an important feature of the data visualization module that enables you to choose information you don’t want to include in your data analysis, and that should not be displayed on the graph.

To add a filter to a chart, from the Filters page of the Chart editor, select a measure or a dimension.

There are 3 types of filters in the data visualization module:

  • Filter by measure
  • Filter by dimension
  • Filter by time and date

Let’s go through each of them.

Filter by Measure

When applying a measure to filter field, SlicingDice automatically generates the following dialogue:

By default, filter use aggregated values which are displayed on the chart. To use raw values from the source, enable the Apply filter to raw data option.

Under the Show values which are menu the following filter types available:

  • Greater than – matches rows with the column value greater than your input.
  • Greater than or equal – match rows with the column value greater than or equal to your input.
  • Less than – matches rows with the column value less than your input.
  • Less than or equal – matches rows with the column value less than or equal to your input.
  • Equal – matches rows where the filter column equals your input.
  • Not equal – matches rows where the filter column not equals your input.
  • Between – matches rows with the column value less or equal than your input ‘to’ but greater or equal than your input ‘from’.
  • Not between.

Filter by Dimensions

When you add a dimension to filters, the data visualization module automatically generates the following dialogue:

To select which elements should be included and which shouldn’t stay on the Select tab. Check all the elements you need. And remember the search tool is there to help you.

To select the elements that match an expression (string), click the Wildcard tab. You can include or exclude elements that contains/starts/ends or exactly match an expression. For example, you can select all URLs that contain /share/.

To select top/bottom N elements from your dimension, choose the Top tab.
Then choose Top or Bottom from the pane, how many elements to select, measure by which the query will be calculated and how the measure should be aggregated.
You can also create an element ‘Others’, which will contain all elements that will not be included in the top/bottom. Please note that the “Others” element won’t be included into sorting and will be always displayed at the end of the chart (for pie charts – at the top left).

Filter by Time and Date

Select a date dimension in the Filter pane and specify the period.

Don’t forget to click APPLY at the top right corner of the pane when the filter is ready.

Since time and date are also dimensions, you can switch to the List view, specify the level and choose separate years/months/days in the filter.

NOTE: You can’t add more than 3 date filters to one chart.

Step 6 - Add sorting

The data visualization module offers the ability to sort and order data in various ways. This is when you have a table and you would like, for example, the top sales to be in the top rows. Also, you can use this to order a bar chart so that the longest bars are at the top and the shortest ones are at the bottom.

To sort / order data, go to the Sort page of the Chart designer and select one of the dimensions which are added to a chart.

The data visualization generates the following dialogue:

  • Data source order – the default sorting of elements of a selected dimension. They appear as they come from the dataset.
  • Alphabetic – you can order elements by the alphabet ascending (from A to Z) or descending (from Z to A).
  • Measure – sort elements ascending or descending by measure.
  • Manual – you can move elements up and down to let them go as you want.

Don’t forget to click APPLY at the top right corner of the Sort pane to add sorting to a chart.

Step 7 - Customize your chart

SlicingDice's data visualization module allows you incredible freedom in customization options. Select colors, tooltip style or enable drilling from the Chart tab of the Format page. Change the title, labels style or add trendline from the Elements tab. Save the chart style as a template for future use on the Style tab.