Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi try
firstsortedvalue(max_date , aggr(max(date([max_date], 'MM/DD/YYY')),name))
Try this script level
LOAD Name,
Max(Date) as Date
Resident TableName
Group By Name;
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.
It can't be hidden, this is is because selections are applied on aggregated dimensions
Try this
=aggr(max(date([max_date], 'MM/DD/YYYY')) as MaxDate, name)