Count number of groups when in group view

There is a workaround that will get you the number you want, but it’s not pretty…
Should only take about 5-10 minutes to set up.

• Step 1:
  Create a new table called “Summary” or some-such

• Step 2:
  Create a linked record field in your grouped table that links to a single record in “Summary”

• Step 3:
  Link every single record in your grouped table to the same record in “Summary” (this can be achieved by linking the top record, then copying that field, selecting that field for all records [ctrl/cmd + shift + down arrow] and pasting)

• Step 4:
  Create a rollup field in the “Summary” table that rolls up the same field you are grouping on from your other table, using this formula in the rollup field:

COUNTA(ARRAYUNIQUE(values))

This will count the unique values from the field rolled up, and that count will match the number of groups that exist in your grouped table, because a group is created for each unique value in that field.

This worked perfectly. Thank you so much!

Adding this response in case someone else comes across this as I did, as there is a much easier solution.

Fixed to the bottom of the table view, look for a grey footer bar. By default, it seems to display the total number of records in the leftmost corner. As you hover over this footer, below each of your table’s columns will appear a “Summary” label. Click this, and a dropdown giving you a number of options will appear.

From the options in this dropdown, select “Unique” and the footer will then display the number of unique values within that column.

That’s it! :slightly_smiling_face:

Oooh, thanks for sharing! I haven’t noticed that before! That’s a hot tip! :slightly_smiling_face:

Just to follow up on this, neither solution presented thus far works for me. The lengthy (and unseemly) process of creating a summary table just to count the number of groups ended up failing with the formula just calculating 1 unique value… And the options on the Summary bar at the bottom of the main sheet doesn’t have the “Unique” option for this column for some reason.

Would be great to have an easy way to analyze the number of groups created by a grouped view.

You wouldn’t create another table to count the number of unique groups. You would do it from the groups table.

That was in response to Jeremy_Oglesby’s solution above (Step 1: Create a new table).

But also as mentioned, from the groups table at the bottom when you click on “Summary” the option “Unique” is missing on the column i need to find unique counts for…

Right, me too. I had to manually count my groups…the unique attribute was not on the grouped column…

Hi to all!

Unique gives the same count as I don't visualize items grouped 😞

Hi!

     @JoshApos I found this solution, but the options available for the status of the ticket do not include the count of them.

     I want to know the percentage of each groupped topic under the total of tickets.
     But seem only numeric fileds have percentage option.

Any further hint?