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

Ok, so this one has me stumped. Client has a re..

Avatar

Level 2

Ok, so this one has me stumped.

Client has a report that shows the record count of a user's name in a custom field. They'd like to only see those users with a record count of 4 or more and still see that user's total number of records. On a graph, if possible.

Thanks!

Topics

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

2 Replies

Avatar

Level 10

Hi Jason,

If this were SQL, what you're after is a "TOP" function...but alas, it is not available (yet).

So as a hack...

Depending on where that user's name count is coming from, if you can persist it as custom data (e.g. in a calculated parameter), you could then filter on it (e.g. >4), and sort on it (e.g. descending on that count), and chart it.

Regards,

Doug

Avatar

Level 2

And so, I patiently wait for more functions, lol. Thanks Doug!