Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Can you limit a report to only show multiple rows of a particular grouping?

Avatar

Not applicable

The scenario: I want to build a report that shows if two projects are working on the same compliance code. I have this code in the custom form and am able to group by it to manually scroll and see where they are multiple rows so people aren't working on the same piece in different projects. So far so great.

The challenge: There are 300 open projects, and only a small number of instances in which there are two projects sharing this attribute. I'd rather only see the ones where the groupings are more than 1. Alternatively, being able to at least sort so the multi-row examples are at the top is another way to highlight the key data quickly.

Any insight into how/if this can be done? Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Employee

Ryan - I'm not sure if you've tried this already, but applying a chart may help (if it doesn't error out because of too many results). There's not currently a way to sort a grouping based on the number of results, however, a chart may help you easily identify which projects are sharing the same compliance code because those columns/bar/pie slices would be larger than the others.

I'm not sure if anyone else has other suggestions, but this may be a good starting point!