Jump to content
  • 0

Displaying The Most Recent Records Based On A Field


DataCobalt
 Share

Question

Hello everyone.

 

I am looking to be able to filter a result table to only show the most recent record of each type.

 

In this instance it is based on certifications.

 

The relationships in my table are Employee>certifications>trainings

 

Lets say Employee Joe Smith has 6 certifications, each of these has been recertified (training) 4 times.

 

I would like to be able to display one table or even one row that shows only the most recent date that each certification was redone. Ideally this would be in a table grouped by certification type (for example: Forklift training, First Aid, CPR, Ergonomic Lifting).

 

I know that one way to do it would be to have multiple data pages that are limited to one result as the latest date, and filter it by certification type. However, that could end up with over 15 datapages being deployed on one page and will eat through them quickly as our customers add certifications they would like to track in this snapshot view.

 

Any and all help is appreciated, thank you.

 

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...