How would the data be ordered if I specify an option field or categories for the "Group by" option on the chart setting and then sort the data?

Article Number:040199

This page explains how data will be ordered when you specify option fields or categories for the "Group by" option on the "Graph" settings screen and then sort data.

"Option fields" refer to the following:

  • Radio button
  • Drop-down
  • Check box
  • Multi-choice

When You Specify an Option Field

If you specify one of the above fields for "Group by" on the "Graph" setting screen and sort data, the data included in the chart will be in the order defined in the "Options" on the settings screen of the option field.

The following is an example for this case.

  • You have configured "Options" in the order of "A," "C," and "B" on the drop-down field setting screen.

  • Also, you have configured the following options on the "Graph" setting screen.

    • Chart Type: Bar chart, Clustered
    • Group by (Level 1): Drop-down
    • Function: Count (Number of Records)
    • Sort by: Level 1, Ascending

In this case, the chart shows data in the following order.

Drop-down: A
Drop-down: C
Drop-down: B

When You Select Categories

If you specify Categories for the "Group by" option on the "Graph" setting screen and sort data, the data in the chart will be listed in the order defined in the Category Tree. You cannot change the order even if you reorder items in the Category Tree after creating and saving them.
If you added multiple categories at one time and saved them, they will be listed in the order when they were saved, not when they were added.

The following is an example for this case.

  • Example of Categories settings
    Suppose that you configure categories in the order of "1", "3", and "2" in the "Category Tree" on the Categories settings screen.

  • Also, you have configured the following options on the "Graph" setting screen.

    • Chart Type: Bar chart, Clustered
    • Group by (Level 1): Categories
    • Function: Count (Number of Records)
    • Sort by: Level 1, Ascending

In this case, the chart shows data in the following order.

Category: 1
Category: 3
Category: 2