You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > HappyFox BI > Working with Data > How to combine the values of a text field?
How to combine the values of a text field?
print icon

HappyFox BI allows you to combine the values of a text field values into groups to help you analyze them.


For instance, let’s say you want to view tickets that are currently in 'Open' or 'In Progress' status against the rest of the other tickets, you need to combine all the ticket statuses except ‘open’, 'In Progress' status into one group and the rest of the tickets into another group. Combine values feature helps you achieve this grouping.


Steps to be followed:

  1. Scroll over the desired visualization and click on the ‘Edit Visualization’ button on the top right of the visualization. (If you have not created a visualization, learn about creating a visualization)

  1. Under the general settings tab, click on edit symbol next to the text field you would like to combine the values

  1. Edit field window opens, now enable the ‘Combine values’ option below the text field


  1. Now add the name for your group and choose the values under each group

  2. Click the ‘+’ symbol to keep adding groups

  3. To combine all the other values into one group, check the “group all values”.

  4. Once your groups are ready, click add.

  5. You can now see the grouping for the field on the visualization.  







0 out of 0 found this helpful

scroll to top icon