Documentation

Group Results

Adding a field to the Dimension area will group your results into categories that appear on the X-Axis of your chart. In some cases it might be more useful to define these groups by yourself or to aggregate several values from your field in the dimension area into one group. In the following we will demonstrate how to define your own groups and create customized field values that will be shown on your chart axes.

 

  1. In the Chart Creator, drag and drop the fields you would like to measure from the left table structure into the visualization area on the right.
  2. To customize your groups click on the field in the Dimension or Decompose by area to open the Field Editor on the right side of the screen.
  3. Select the Groups tab on top of the Field Editor.
  4. Now, Click the Add Group Button. This will create an empty group below.
  5. Name your group and select the values that should to be added to the respective group by checking the checkboxes next to the field values in the List of field values.
  6. Click on Save below the List of field values to save the group that you are currently working on. Be aware that every value can only be added to one group at a time. To create another group, click on Add Group again.
  7. Confirm your groups by clicking on the Apply Button at the bottom of the Field Editor. This will populate your changes to your chart.

how to group results in datapine

 

Go back to the Properties tab on top of the Field Editor. Your groups will now appear as field values. By selecting the checkboxes next to the field values and clicking Apply you can exclude or include specific values from your chart.

 

If you want to edit another group, go back to the Groups tab in the Field Editor and click on the Edit Button next to the group name. This will open the List of fields below. You can now select or deselect additional values. Save your changes by first clicking on Save and then applythe new group to your chart.

 

Tip:

 

Use the grouping function if you like to do a demographic analysis on a metric. Therefore, put age and gender in the X-Dimension and use the grouping function to build age segments. This will automatically split the age segments by gender.