All Collections
Reports
Custom reports
Custom report chart types and options
Custom report chart types and options

Use specific chart types and options to visualize conversation or ticket data that’s important to your business.

Mariah avatar
Written by Mariah
Updated over a week ago

Chart types

There are six chart types to provide you with flexible ways of visualizing your data, including: KPI, column, line, donut, area, and table.

KPI chart

KPIs are the perfect way to get a quick summary without the need for a detailed breakdown of your data. This chart will show an average calculation of the data for the period select.

Column chart

With a simple column chart, you can break down the data by conversation data attributes, user data or other metrics & properties in Intercom.

You can also define exactly how many of the top groups to show.

With a column chart, segmenting the data lets you visualize it in two dimensions. In this example you can see the columns are grouped by "Week", and segmented by the “Team currently assigned”:

Line chart

Line charts offer the same options to view and segment your data, but are better suited to showing trends over time.

When using the line chart type, if selecting 'view by: time' with a single point, the line series on the charts will appear as a single dot. You will need to select a smaller time granularity to see change over more than one breakdown.

Table chart

A table gives you a sortable list of values broken down by the dimensions you choose, for example this shows "New conversations" by week, segmented by "Teammate currently assigned".

Donut chart

A donut chart is a visual representation that shows parts of a whole by dividing a into segments. This chart is excellent for comparing the relationship among multiple attributes for a single metric, offering a clear and concise visual representation.

A donut chart cannot be segmented down further and can only show one view by layer. Donut charts also do not support the following chart options:

  • Targets

  • Time comparisons

  • Stacked chart

Area charts

An area chart enables you to observe the cumulative effect of data points over time. By filling in the area between lines with colors and shading, it offers an enhanced perspective on the volume or total of the data points, making it easier to comprehend the overall impact.


Chart options

  • Aggregation methods: We have two aggregation methods for time-based and ratio metrics: SUM and Percentile. These methods provide more precise and flexible options for analyzing your data, offering deeper insights and a more nuanced understanding of your metrics.

  • Time period comparison: Enhance your analysis with the ability to visually compare a metric across two different time periods. This feature provides a straightforward way to identify trends, changes, or improvements, facilitating a better understanding of temporal shifts in your data.

  • Targets: You can set and compare your metrics against manually inserted targets in selected chart types. This feature adds an extra layer of analysis, allowing for goal-oriented evaluation and tracking.

  • Relative stacked charts: The relative chart option feature in stacked area or column charts enables you to visualize each attribute's proportional contribution to the overall total, offering a clear comparison of individual elements within the context of one data point.

  • Table summary row: There is an option to add a 'summary' row to tables, which displays the aggregated value for each column, providing a concise overview of key data at a glance.

The Options tab contains more settings which allow you to customize certain elements of a chart.

The 5 available options are:

  • Compare to previous period

  • Stacked

  • Show relative values

  • Show data labels

  • Show target

Not all options appear on every chart type. Use the table below to see which options are available in each chart type:

Chart type

Compare to previous period

Stacked

Show relative values

Show data labels

Show target

KPI

Column

Line

Donut

Area

Table

Aggregation methods

There are multiple aggregation methods available on time based metrics and ratio metrics.

Average: The total of all values divided by the number of values. For example, if you have five response times of 1, 3, 4, 5 and 6 minutes, your average response time is all of them added together (1 + 3 + 4 + 5 + 6) divided by the number of responses (5) which equals 3.8 minutes.

Median: The middle value in all of your response times. The middle value is what separates the higher half from the lower half of your total response times. For example, if you have five response times of 1, 3, 4, 5 and 6 minutes, your median response time is 4 minutes (the middle value).

Percentile: Existing options like the minimum (1st percentile) show the lowest value, the maximum (100th percentile) the highest, and the median (50th percentile) the middle value of a dataset; now, with the new feature, customers can choose any percentile between 1 and 100. Custom percentiles offer a more nuanced view of your data. While the median gives a good sense of the middle, and the min/max provide the range, custom percentiles allow you to analyze specific segments of your data distribution, tailoring your insights to your specific needs or goals.

Minimum: The smallest value from the time period. For example, if you have five response times of 1, 3, 4, 5 and 6 minutes, the minimum value is 1 minutes.

Maximum: The largest value from the time period. For example, if you have five response times of 1, 3, 4, 5 and 6 minutes, the maximum value is 6 minutes.

Sum: The main function of the sum aggregation is to calculate the total of numerical values. This operation is executed on one or more attribute columns within a dataset, that are used in defining metrics. It's only applicable to numeric data types, such as integers and decimals. During this process, the sum operation iteratively adds the value from each row of the specified column(s), accumulating a running total.

Time period comparisons

"Compare to previous period" enables you to visually compare a metric across two different time periods.

For example, if you're analyzing the First response rime (FRT) over the last 12 weeks and select the option "Compare to previous period", the chart will display both the data for the most recent 12 weeks and the data for the 12 weeks preceding them.

Time period comparison only works when you view by time. It will not work when you view by or segment by any other attributes.

Targets

You can set and compare your metrics against manually inserted targets in selected chart types. This feature adds an extra layer of analysis, allowing for goal-oriented evaluation and tracking.

You can compare your metrics to a manually inserted target in the below chart types:

  • KPI

  • Column

  • Line

  • Table

  • Area

The table chart type employs a conditional color scheme depending on the chosen metric. For example, with a metric like "closed conversations" and a target of 500, values below 500 are displayed in red, while those above 500 appear in green. Conversely, for metrics where lower values are preferable, such as first response time, values falling below the target are shown in green, and those exceeding the target are highlighted in red.

Relative stacked charts

The relative chart option feature in stacked area or column charts enables users to visualize each attribute's proportional contribution to the overall total, offering a clear comparison of individual elements within the context of one data point.

Note:

  • The relative chart option will only be enabled when the “Stacked” option is enabled.

  • Relative stacked charts are only available on column and area charts.

Table summary row

Customers can add an additional “summary” row to a table via a chart option. The summary row shows the aggregated value for each column of a table.

The summary row is not the same as a total row. It is possible that the values in each row do not add up to the value displayed in the summary for certain metrics.

Consistent data series colors

The data series in charts and reports maintain a consistent color, ensuring uniformity and ease of recognition across different visualizations. For example, when a chart is segmented by channel, the data series “chat” will be blue in all charts.


💡Tip

Need more help? Get support from our Community Forum
Find answers and get help from Intercom Support and Community Experts


Did this answer your question?