Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

help with ordering information

Hi everyone,    I am building a dashboard to track certification.  Each certificate has its own row and uniqe ID number.  The comonality is the course the certificates are registered against has a ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I'm sorry I can't uplod the data but perhaps I can explain a little more. 

     

    Each person does hazard management training every two years. each time they complete it a certificate is recorded it issues a certificate. so a person could end with 5 certificates if they ahve been here ten years. What I want the system to do is only show me the most recent certifcate and forget all the rest? 

    Each course and user has a unique idenitifier 

     

    Thanks

    heaps

     

    Amy