Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need to create a new expression to use in table. The expression should incorporate our 'completed_at' date field i'm pretty sure, but I want it to pull dates only within, lets say, a two month period.
The expression I have so far is:
Sum({<completed_at={>=$(=Max(completed_at)-60))
Any help is appreciated. Thanks in advance.
Hello,
The syntax would be
{<TIME_KEY = {">$(vFirstPeriod) <$(=vLastPeriod)"} >}
So.
Sum({<completed_at={">=$(=Max(completed_at)-60)<$(=completed_at))"}>}ABCD)
Thanks.
When you use >= within set analysis you need to use quotation marks - single or double depending upon the contents. For your purposes you should get away with something like the following:
Sum({<
completed_at={'>=$(=(Max(completed_at)-16))'}
>}
ValueToSum)
Hope this helps.