Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Anchor
top
top

Table of Contents
classcontents

Overview

Styleclass
ClasstopLink

top

 You can change the data returned for selected fields on your report by grouping the values. This provides you with the ability to add additional layers of analysis to your reports.

Grouping Age Example

The example below groups the results of the age column into a segment group. People with an age 13 and 18 (inclusive) are grouped as teenagers.
For example:

Section
Column
width125px

Age

Sales

16

$1,500

17

$750

25

$1,300

Column
width150px

Update ages to group all between 13 and 18 into a Teen bucket.

Column
width99%

Age

Sales

Teen

$2,250

25

$1,300

 

Grouped Metrics

Styleclass
ClasstopLink

top

Grouped Metric setup has a different behaviour to other types of grouped fields, as Yellowfin will automatically create groupings for you, which you can then adjust.

1.  Click the drop down list on a view field and select the New Grouped Data Field option. Alternatively, click on the Create button at the bottom of the View Fields list and select Grouped Data.

Image Modified

You will now see the Group Data lightbox.

2.  Provide a name for the field, and specify which view field it should be based on.

3.  Click Continue to begin designing groups.

Image Modified

When it comes to metrics, Yellowfin will automatically provide groupings, which you can then adjust.

4.  Click Edit Groups to make adjustments to the auto groups.

Image Modified

5.  You can now specify the number of groups Yellowfin divides your data into.

 

Image Modified

6.  If you want to further edit the groups, disable Auto Groups.

7.  You can now change the labels and value ranges for the groups.

8.  Click Save to complete your changes.

Image Modified

9.  Click Submit to complete your grouped data field.

Image Modified

 

Grouped Text

Styleclass
ClasstopLink

top

1.  Click the drop down list on a view field and select the New Grouped Data Field option. Alternatively, click on the Create button at the bottom of the View Fields list and select Grouped Data.

Image Modified

You will now see the Group Data lightbox.

2.  Provide a name for the field, and specify which view field it should be based on.

3.  Click Continue to begin designing groups.

Image Modified

4.  Provide a label for your first grouping. This will be what's displayed instead of the grouped values.

5.  Pick an operator for your grouping logic:

Operator

Description

In List

One or more alphanumeric or string values

Not In List

Two or more alphanumeric or string values

6.  Select which values should be used in this group, moving them from the list on the right to the list on the left.

7.  Click Save to complete this group.

Image Modified

8. To add additional groups, click on the + Add Group link.

Image Modified

9. Define and save your additional groups.

Image Modified

10.  You can reorder your groups by clicking and dragging the Image Modified icon.

11.  Edit a group by clicking on its label.

12.  Click Submit to complete your grouped data field.

Image Modified

 

Grouped Dates

Styleclass
ClasstopLink

top

1.  Click the drop down list on a view field and select the New Grouped Data Field option. Alternatively, click on the Create button at the bottom of the View Fields list and select Grouped Data.

Image Modified

You will now see the Group Data lightbox.

2.  Provide a name for the field, and specify which view field it should be based on.

3.  Click Continue to begin designing groups.

Image Modified

4.  Provide a label for your first grouping. This will be what's displayed instead of the grouped values.

5.  Pick an operator for your grouping logic:

Operator

Description

Equal ToThe same as the specified date.
Different FromDifferent to the specified date.
Greater ThanA date later than the specified date.
Greater Than or Equal ToA date the same or later than the specified date.
Less ThanA date before the specified date.
Less Than or Equal ToA date the same or before the specified date.
BetweenA date in between the two specified dates.
Not BetweenA date outside of the two specified dates.
In ListA date the same as one in the list of specified dates.
Not In ListA date not found in the list of specified dates.
Is NullA null date.
Is Not NullA date.

6.  Select which values should be used in this group, moving them from the list on the right to the list on the left.

7.  Click Save to complete this group.

Image Modified

Image Modified

8.  Click Submit to complete your grouped data field.

Image Modified

 

 

horizontalrule
Styleclass
ClasstopLink

top