Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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!