Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Need help: in calculated metric by dividing specific month vs last year's month

Avatar

Level 1

Hello,

I'm in the process of creating an engagement score using the calculated metrics in Workspace (essentially, an aggregate of 7 metrics that is indexed from previous year's same month and then weighted). 

Is there a way to have Adobe Analytics divide a month to its previous year's month (13 months back)?  So, January 2019 vs January 2018, etc.  This would be in the Calculated Metrics section of Workspace.

Thank you!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

basically you could create a segment with the desired "date range" in it. so create 2 "hit-segments" with date ranges "13 month ago" and "last month" in it. then create the calc. metric by applying the segments to the desired metrics.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

basically you could create a segment with the desired "date range" in it. so create 2 "hit-segments" with date ranges "13 month ago" and "last month" in it. then create the calc. metric by applying the segments to the desired metrics.