aggr() function displays the aggr dimension as the selection value

[1600eads]

I have an expression

=aggr(max(date([max_date], 'MM/DD/YYY')),name)

The main issue is, when I bring this expression as a filter, the filter name will show 'name' under the selection bar. It looks to display the dimension the expression was aggregated on. Is there a way to display max_date instead of name when using this aggr expression on the front end? 

Thank you.

[brunobertels]

hi try 

firstsortedvalue(max_date , aggr(max(date([max_date], 'MM/DD/YYY')),name))

[qv_testing]

Try this script level

LOAD Name,

          Max(Date) as Date

Resident TableName

Group By Name;

[1600eads]

Thanks for the feedback! I was able to achieve this relatively easily by doing a right(max_date, 10) in the format of 'MM/dd/YYYY' and saving that as a master dimension.

The resident load would've been fine as well but that would've caused some extra load to time for our user base which I wanted to avoid. 

[vinieme12]

It can't be hidden, this is is because selections are applied on aggregated dimensions

[Chanty4u]

Try this

=aggr(max(date([max_date], 'MM/DD/YYYY')) as MaxDate, name)