Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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

Community Advisor

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!