Help

Is there a way to get the count in group view?

Topic Labels: Formulas Views
1436 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Pursarth_Tuladh
4 - Data Explorer
4 - Data Explorer

Hi, i would like to ask for help if there's a way to get the count in group view maybe via automation or scripting. (please see screenshot). Though we have a count My goal is to check one of my field when the program is under the same metro schools - cna & other licenses and same provider full name. Most likely, if the highlighted number here is 1 it should automatically be checked. 

Pursarth_Tuladh_0-1682402939742.png

On the other hand, there are instances when the highlighted number is more than 1.  (please see screenshot below). In this case, I will just randomly check anything or base it in the program with Upcoming class.

Pursarth_Tuladh_1-1682403077031.png

For now, I manually check all the programs which is very time consuming. I hope you can help me. Thank you!

3 Replies 3

There are many ways to seek duplicates, but recently I found a very helpful stuff when grouping by 2 or more levels . Instead of count, I'm using Percent Unique and switch to 'Collapse All'. Values, different from 100% are clearly visible, and reflected on each group/subgroup level.

Please show me how to do this. Thanks!

Pursarth, you simply left click on the small arrow beside the header. 

GrahamW_0-1682524736868.png