Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data that has Id, Condition, Status as Dimensions with Date and Time as Dimensions. I need to display only the latest entry. This needs to be done in the front end, not in script.
For example,
Straight Table:
Desired results:
Any ideas? Thanks!
Hi,
create a new dimension in the script Date+Time as DateTime,
then in the table' insted of Date field create a calculated dimension:
=Aggr(Only({$<DateTime={"=Aggr(rank(DateTime,4),ID,date,time)=1"}>}date),ID,date,time)
then uncheck "Include Null Values"
i am attaching an example.
BR
BR,
Thanks for the quick response. Unfortunately, I can not modify the model/script to include a new dimension. Business dictates that the date and time need to be separate dimensions. This is why I was looking to do this in the 'front end' only so performing set analysis is not possible.
Thanks for the effort!
Kevin.....