Only Display Most Recent Data in Dropdown

[danshanahan]

Hey everyone.  I'm trying to create a visualization expression which only displays fields that are from the most recent data set.

Here's an example of my data:

id	business unit	updated at
123123	bu1	2/01/2021
123123	bu2	2/02/2021
222222	bu3	2/02/2021

I'm wondering if there is a way to only return the business unit names from the most recent date?  In this case, I would only display bu2 and bu3.

I've tried a set expression and FirstSortedValue([business unit], [updated at]), but neither worked.

Any thoughts?  Thanks!

[edwin]

normally i would create a variable that holds the date:
vMaxDate = date(max([updated at]))

then in set analysis:
{<[updated at]={'$(vMaxDate)'}>}

hope that helps

[Chanty4u]

you can use

SET DateFormat='DD/MM/YYYY';

Dimension: ID

Expression : Date(max([updated at]))

[agigliotti]

Hi @danshanahan ,

You could use the below expression for your listbox.

=Aggr( if( [updated at] = date(max( total [updated at])), [business unit] ), [business unit] )

I hope it can help.

Best Regards

[danshanahan]

I was able to get this with a an aggregation and set expression:

=aggr(only({<uploaded_at = {"$(=Max(updated_at))"}>} business_unit),business_unit)

Thank everyone for the help!