hey,
I want to create a growth metric, that calculate the diff between today’s value and the avg 30 last days excluding today.
in order to do so I am trying to create a calculated field for these 30 last days excluding today, however the start index direction is only above, wheres I need it to be -1.
when trying to put -1 I’m getting an error.
this is the calculation I am using:
windowAvg
(
{# Onboarded - Daily},
[{DATE} DESC],
-1,
30
)
would love to hear on a workaround or how to handle this.
thanks
Hi @alon ,
the windowAvg only allows positive integers as input.
To receive your target, you can calculate the average for the last 31 days including today. Multiply by 31 to receive the total amount, then substract the value from today and divide by 30. That should be the correct value.
Best regards,
Nico
1 Like
Hi @alon,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @alon,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.
Thank you!