Insights Overview

This tutorial will walk you through the Insights. It will explain how to build reports in Statsbot and how to use different chart types as well as various features and settings. We're going to use sample e-commerce store data for all examples.

Let's start with a quick example.

insights overview 1

In the example above, we have displayed the number of orders grouped by day for last 30 days. In our query we used a measure called Orders count and a time dimension Order Completed at.

Measure is referred to quantitative data, such as number of units sold, number of unique visits, profit and so on.

Dimension is referred to categorical data, such as state, gender, product name, or units of time (e.g., day, week, month).

Time field in Statsbot consists of time dimension and filter, such as Orders completed date grouped by day and filtered for last 30 days.

You can change granularity of Time Dimension, as well as filter value. You can disable granularity if you want to. In the example below we disable granularity, but keep the filter to show Orders completed in last 30 days by product category.

insights overview 2

Time Dimension always comes with time filter. You can use it to filter your data within specified timeframes. It could be either absolute values, such as Jan, 2015 - Jan, 2016 or relative, such as last 7 days or last summer.

insights overview 8

If you want to show all data without limiting it to specific dates - just remove Time Dimension completely.

Let's see how many orders we have processed. We can add Orders status dimension to see breakdown of orders by different statuses.

insights overview 3

You can sort table result by clicking on table header and selecting direction. Let's sort orders by product categories to find out the most popular category. We're going to sort our result table by Orders count in descending order. You can sort by multiple columns by clicking on several table headers.

insights overview 4

If you're working with chart visualization or would like advanced sorting capabilities you can use sorting menu to the right under gear icon.

insights overview 5

Statsbot sorts results by default using following rules:

  1. The first time dimension, ascending. If no time dimension exists...
  2. The first measure, descending. If no measure exists...
  3. The first added dimension, ascending.

Statsbot limits returned data to 5000 rows maximum. In you want to, you can change this limit, but not greater than 5000. There are several use cases when you would want to limit your data. For example, if you want to see your top 5 best selling products you need to get orders count by products names, sort by orders count and then limit data to only 5 rows. Limit option is located below sorting under the gear icon to the right.

insights overview 6

Statsbot lets you filter data in different ways based on your needs. If you need to change the time filter, for example to filter orders completed on last week, you can do it by changing Time Dimension Filter. This tutorial covers more advanced filtering.

To add filter click on the plus icon in the Filters section. Next select dimension or measure to filter. The options (or operators) for the filter depend in its type.

When you filtering on text dimensions using equals or doesn't equal operators, Statsbot helps you to select values by displaying a list of existing data values for that field. As you type, Statsbot narrows the list to just those values that include that text.

insights overview 7

Filters are applied differently to dimensions and measures.

When you filter on a dimension, you are restricting the raw data before any calculations are made.
When you filter on a measure, you are restricting the results after the measure has been calculated.

Let's walk through examples to better understand the difference.