Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a stright table that shows; Company, Value and the min(Create_Date).
I'm trying to view only data that has been created since yesterday.
I have created a variables:
vToday = max(Create_Date)
vYesterday = max(Create_Date)-1
However I am struggling with how to use these variables to only shows companies with a min(Create_Date) of yesterday.
Any help is much appreciated.
Regards,
Daniel
In that case, update your Company dimension to if(aggr(min(Create_Date), Company)>=today()-1, Company) and check Suppress Values When Null. (See attached.)
Change your expression from min(Create_Date) to min({<Create_Date={'>=$(vYesterday)'}>}Create_Date). (See the attached for an example.)
Hi,
Try this
sum({<Create_Date={'<=$(=Date(vYesterday))'}>}value)
Regards,
Jagan.
Hi Nicole,
Thank you for your reply.
I think I wasn't quite clear enough in my original message. The table should only show trades where the min create date is yesterday or greater.
As an example:
Company Create_Date
A 26/08/2013
A 27/08/2013
A 27/08/2013
B 20/08/2013
B 26/08/2013
B 27/08/2013
C 20/08/2013
C 21/08/2013
C 22/08/2013
I am trying to produce a table that shows the following as a result:
Company Create_Date
A 26/08/2013
This is because company A is the only company that has a minimum (first) create date of yesterday or greater.
If you are able to help with the above, that would be great.
Thanks,
Daniel
In that case, update your Company dimension to if(aggr(min(Create_Date), Company)>=today()-1, Company) and check Suppress Values When Null. (See attached.)
Thank you so much for your help.
Regards,
Daniel