Skip to main content
Question

Creating a 3-month trailing average for multiple version

  • September 17, 2025
  • 0 replies
  • 27 views

Forum|alt.badge.img+2

Hello All,

I’m currently trying to create 3-month trailing average for multiple dimensions. The formula worked when I only have 1 version dimension but when I tried to create multiple versions, it collapse.

 

Here is my metrics before adding version

 

Metric 1: Trailing 3 months (Boolean)

 

Metric 2: Trailing 3 months calculation

So, you can see Aug 25 is the trailing average for May through Jul

 

Here is what I attempted to replicate after adding version as a dimension.

Version Dimensio

Period Type by Month (by version)

Create a new 3-month trailing boolean for each version

But when I replicate the output, this error popped up 

Any help would be appreciated!

 

Thanks!