Skip to main content

Overview

Transform supports a variety of chart types. You can change Transform chart types on any chart in the application by using the icon with a trend line on the top right-hand corner. Depending on the data selection, the chart types available to you will update. The following chart types are supported: Line, Bar, Area, Single Value, Table. Below are common selection combinations and the types of charts you can use in each scenario:

One Metric Over Time​

Example: Sales over Time

  • Line
  • Bar
  • Area
  • Single Value (it will show the latest available data point for selected granularity)
  • Table

One Metric Over Time with One Grouping​

Example: Sales over Time by Country

  • Multi-Line
  • Stacked Area
  • Share of Area
  • Stacked Bar
  • Grouped Bar
  • Share of Bar
  • Single Value (shows the latest available data point for each grouping)
  • Table

One Metric Over Time with Multiple Groupings​

Example: Sales over time by Country and Product Type

  • Table

One Metric and No Grouping (No Time)​

Example: Sales [with time range of 7 days]

This will aggregate the metric over the 7 day period

  • Single Value
  • Table

Two Metrics Over Time​

Example: Revenue and Quantity Over Time

  • Line (with option of single or dual axes)
  • Table
  • Single Value (shows the latest available data point for each metric chosen)

More than Two Metrics Over Time​

Example: Revenue, Quantity, Sales by Time

  • Table
  • Single Value (Shows the latest available data for each metric chosen)

More than Two Metrics over Time with Grouping​

Example Revenue and Quantity over time by Country

  • Table

More than Two Metrics over Time without Grouping (No Time)​

Example Revenue and Quantity over time by Country

  • Table
  • Single Value (shows aggregation over time range for each metric)

Remarks​

Table view can be used for any selection

Selections with two metrics can be viewed in a single axes or dual axes. If the metrics don't share the same value format, we will always default to dual. As a best practice, if the two metrics are comparable (e.g., gross revenue and net revenue), it is highly recommended to set them into the same value format and use a single axes to visualize the data.

Looking at a metric without any groupings is only supported for a single metric at a time. This will aggregate the metric value over the time range selected.