Grouping


Vous êtes ici: InLoox Support Documentation Aide en ligne InLoox for Outlook 9.0 All support articles | InLoox 9 for Outlook Dashboard views | InLoox 9 for Outlook Design dashboards | InLoox 9 for Outlook Data shaping Grouping

Dashboard allows you to group dimension values and display summaries for entire groups rather than individual values.

You can arrange dimension values in groups of different sizes by specifying the appropriate group interval. For instance, date-time values can be grouped by years, months, quarters, etc.

This topic lists the supported text and date-time group intervals, and describes how to change the group interval.

The following sections are available.

Text group intervals

String values support the following grouping intervals.

No grouping Each value is displayed "as is".
Alphabetical Values are grouped alphabetically. Example: A, B, C, ... Z

Date-time group intervals

Date-time values support the following group intervals.

Year

Values are grouped by the year. Example: 2012, 2013, 2014

Quarter

Values are grouped by the quarter. Example: Q1, Q2, Q3, Q4

Month

Values are grouped by the month. Example: January, February, March, ... December

Day

Values are grouped by the day of the month. Example: 1, 2, 3, ... 31

Hour

Values are grouped by the hour. Example: 0, 1, 2, ... 23

Minute

Values are grouped by the minute. Example: 0, 1, 2, ... 59

Second

Values are grouped by the second. Example: 0, 1, 2, ... 59

Day of the Year

Values are grouped by the day of the year. Example: 1, 2, 3, ... 365 (366 in a leap year)

Day of the Week

Values are grouped by the day of the week. Example: Sunday, Monday, Tuesday, ... Saturday

Week of the Month

Values are grouped by the week of the month. Example: 1, 2, 3, 4, 5

Month-Year

Values are grouped by the year and month. Example: January 2012, February 2012, ... December 2012, January 2013, ...

Quarter-Year

Values are grouped by the year and quarter.

Example: Q3 2013, Q4 2013, Q1 2014, Q2 2014, ...

Day-Month-Year

Values are grouped by date. Example: 3/4/2014, 3/5/2014, 3/6/2014, ...

Date-Hour

Values are grouped by date with the hour value. Example: 3/4/2014 0:00 AM, 3/4/2014 1:00 AM, 3/4/2014 2:00 AM, ...

Date-Hour-Minute

Values are grouped by date with the hour and minute values. Example: 3/4/2014 0:00 AM, 3/4/2014 0:01 AM, 3/4/2014 0:02 AM, ...

Date-Hour-Minute-Second

Values are grouped by date with the hour, minute and second values. Example: 3/4/2014 0:00:00 AM, 3/4/2014 0:00:01 AM, 3/4/2014 0:00:02 AM, ...

Changing group interval

To specify the group interval in the Designer, invoke the data item menu and select the desired group interval. Less common group intervals are organized in the More submenus.