Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I created a table with Name as dimension, and the Status us a measure with this formula '=FirstSortedValue(DISTINCT Status, -Date)'
Name | Status |
RefA | Completed |
RefB | Pending |
RefC | Removed |
How can I make that measure (resulting Status column) to be able to filter (magnifying glass) on the table?
@ynottableau Could you please use the below expression in your Dimension:
Aggr(FirstSortedValue(Status, -Date),Name)
If this resolves the issue, please like and accept it as a solution.
@ynottableau Could you please use the below expression in your Dimension:
Aggr(FirstSortedValue(Status, -Date),Name)
If this resolves the issue, please like and accept it as a solution.
This solution does not work. Your AGGR is allowing you to select a 'Name' rather than a 'Status'. I am not sure there is an actual solution as I have the same problem.