Chart Types and Their Usage

This section explains the chart types that can be selected in the graph feature and the usage.

Bar and Column chart

A type of graph where bars are used to express the total of each item

Clustered graph

A type of graph that is suitable for use when comparing the total between items
Records are categorized by the value of the item that is specified in "Group by", and the total for each group is represented in a bar. Clustered bar graph

Stacked graph

A type of graph that is suitable for comparing the percentage of the total for each item against the whole, and the overall totals across all items.
Records are categorized by the value of the item that is specified in "Group by", and the total for each group is stacked and represented in a bar. Stacked bar graph

100% stacked graph

A type of graph that is suitable for comparing the percentage of the total for each item against the whole.
Records are categorized by the value of the item that is specified in "Group by", and the percentage of the total for each group against the whole is represented in a bar. 100% stacked bar graph

Line chart

A type of graph that is suitable for showing the chronological variance of the total. Line chart

Spline chart

A type of graph that is suitable for showing the chronological variance of the total. Each point in the graph is connected by a smooth curve. Spline chart

Area chart

A type of graph where the total for each item is represented in a line, with the area from each line towards the X axis is filled with a different color.

Non-stacked graph

A type of graph that is suitable for presenting the chronological variance of the total, and the difference of the total for each item.
Records are categorized by the value of the item that is specified in "Group by", and the total for each group is represented in a line. Area chart

Stacked graph

A type of graph that is suitable for representing the chronological variance of the total for each item, and the variance of the overall totals.
Records are categorized by the value of the item that is specified in "Group by", and the total for each group is stacked and represented in a line. Stacked area chart

100% stacked graph

A type of graph that is suitable for representing the chronological variance of the percentage of the total value for each item against the whole.
Records are categorized by the value of the item that is specified in "Group by", and the percentage of the total for each group to the whole is represented in a line. 100% stacked area chart

Spline area chart

A type of graph where the total for each item is represented in a smooth curve, with the area from each line towards the X axis is filled with a different color.

Non-stacked graph

A type of graph that is suitable for presenting the chronological variance of the total, and the difference of the total for each item.
Records are categorized by the value of the item that is specified in "Group by" and the total for each group is represented in a smooth curve. To express the difference of each group, the area from each curve towards the X axis is filled with a different color. Spline area chart

Stacked graph

A type of graph that is suitable for representing the chronological variance of the total for each item, and the variance of the overall totals.
Records are categorized by the value of the item that is specified in "Group by" and the total for each group is stacked and represented in a smooth curve. Stacked spline area chart

100% stacked graph

A type of graph that is suitable for representing the chronological variance of the percentage of the total value for each item against the whole.
Records are categorized by the value of the item that is specified in "Group by" and the percentage of the total for each group to the whole is represented in a smooth curve. 100% stacked spline area chart

Pie chart

A type of graph that is suitable for representing the percentage of the total for each item against the whole.
Records are categorized by the value of the item that is specified in "Group by" and the percentage of the total for each group to the whole is represented in a pie. Pie chart

Table

If you want to focus more on figures rather than differences or variances of summarized results, the list view is more suitable than the graph view.

Table

In this format, summarized results are expressed in numbers either without being categorized or being categorizing in one field.
For example, for the field "Frequency of convenience store use", you can set the table to obtain figures for 27 records whose value is "Every day", or 90 records for "More than twice a week". Image

Pivot Table

In this format, records are categorized into multiple fields, and figures of summarized results are calculated and summed up row-wise and column-wise.
For example, using the frequency of convenience store use of the previous table, you can create a pivot table that represents the breakdown of the age profile. Specify "Frequency of convenience store use" for "Level 1" and "Age" for "Level 2" to summarize the values. Image