Report only latest row from group

Cody Dean shared this question 2 years ago
Answered

I have a dataset that I am reporting on - I want to report on only the latest/most recent of a group of items. For example, I have three entries for Shoes, I only want to include the most recently updated on on my report. I have it sorting by date - so the last or first entry in a group would work as well.


Example:

/30bdceba8269917a7be9cfccb88b7374

Replies (4)

photo
1

Hello Cody,

You should be able to use the 'Max' Aggregation option on that date field to return only the most recent result.

Here is the Wiki document on Aggregation: https://wiki.yellowfinbi.com/display/yfcurrent/Aggregation

Please let me know if that works for you.

Have a great day!

David

photo
1

Hi Cody,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?


Regards,

David

photo
1

Hello Cody,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?


Thank you,

David

photo
1

Hi,


I hope things are going well over there.


Assuming we're all good here, so I'll flag this as answered. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.


Have a great day!

David

Leave a Comment
 
Attach a file