Hi ,
I am looking to have a visualizations that shows all the [Accounts] with a [Status] = 'NEW' at the last [Date],
The expressions I have been trying to create only keeps the last date,
I am trying see their evolution through time,
so I need them to have the value NEW at last date but I don't want the last date to be chosen, I want to see all dates,
for example what I have been doing :
count( {$<[Date] = {"$(=MaxString( TOTAL [Date]))"} , [Status] = {'New'} >} distinct [Accounts] )
or
if ( [Date] = MaxString( TOTAL [Date]) and [Status] = 'NEW' , count( distinct [Accounts] ) )
Thank you