Skip to main content

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

  • April 25, 2023
  • 3 replies
  • 67 views

Forum|alt.badge.img+1

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. 

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.

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

3 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1260 replies
  • April 25, 2023

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.


Forum|alt.badge.img+1
  • Author
  • New Participant
  • 1 reply
  • April 26, 2023

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!


GrahamW
Forum|alt.badge.img+12
  • Known Participant
  • 31 replies
  • April 26, 2023

Please show me how to do this. Thanks!


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