topic Re: Dimension/ Measure Expression in App Development

Dimension/ Measure Expression

Anonymous — Thu, 16 Aug 2018 15:12:17 GMT

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.

Re: Dimension/ Measure Expression

vamsee — Thu, 16 Aug 2018 15:31:02 GMT

Hello,

The syntax would be

{<TIME_KEY = {">$(vFirstPeriod) <$(=vLastPeriod)"} >}

So.

Sum({<completed_at={">=$(=Max(completed_at)-60)<$(=completed_at))"}>}ABCD)

Thanks.

Re: Dimension/ Measure Expression

michaelsmith — Thu, 16 Aug 2018 15:31:41 GMT

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.