Anonymous
How would we show how much Measure 1 changed between this month and last month? I tried creating a group which is the difference between those two months: syntax is:
(this_month==1) - (last_month==1)
But that didn't create what we're looking for.
robsmith
Jan 15, 2015
You won't be able to do the subtraction in Groups. You'll have to do it in the Measure. So first clear your groups. If the measure syntax is:
avg(Q1)
... you'll have to change it to:
avg(filter(Q1,this_month==1)) - avg(filter(Q1,last_month==1))
It may help to view the documentation on filter syntax.
Comments