Jump to content
  • 0

Count greater than



My graph shows a count of agreements issued for each parent. I want to display on graph only if count is 2 or more.  How can I limit graph to display only if second record exist for the parent? I want to see exceptions not every record.  When second agreement issued it has a different agreement number. The count displayed is simply the number of agreements issued by parent_ID.

Screen Shot 2020-06-28 at 4.42.49 PM.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

HMMMM I suggest that we use a seperate table then use a task/triggered action to copy values there that has second records...

Then use that table as the datasource of this chart instead.

We can also add a single field on your table and use task/trigger to mark records that has a second. Then on your filtering for the DataPage, filter it to only include those that are marked

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...