Ok, so this one has me stumped. Client has a re.. | Community
Skip to main content
JasonLe4
Level 2
Feb 3, 2021 2:27 PM UTC
Question

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

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

JasonLe4Author
Level 2
Mar 8, 2021 4:39 PM UTC

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

Translate
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStore
New Participant
Feb 4, 2021 10:57 PM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...