Ok, so this one has me stumped. Client has a re.. | Community
Skip to main content
J
JasonLe4
Level 2
February 3, 2021
Question

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

  • February 3, 2021
  • 2 replies
  • 495 views

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

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
February 4, 2021

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

J
JasonLe4Author
Level 2
March 8, 2021

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

Terms & ConditionsAccessibility statement

Loading footer...