Expand my Community achievements bar.

Adobe Analytics Champions applications are now OPEN! Applications are open through June 2nd. Click the link to learn more and apply.

Combining multiple calculated metrics to get an average.

Avatar

Level 1

Screen Shot 2023-04-20 at 11.05.48 AM.png

I want to combine PQ/5, PQ4 and PQ4 to get an average weekly. PQ/5 is purchase quantity divided by fiscal week in Jan which equals 5 weeks. PQ/4 is for months that have four weeks using the fiscal calendar. The outcome would replace PQ/AVG Weekly which is just giving me the weekly avg for April. I would like it to be the avg of PQ5 Jan, PQ/4 Feb and PQ/4 March.

5 Replies

Avatar

Community Advisor

You should be able to do this... I don't have your PQ# caculated metrics, so I just threw up a PV/V calculation by month.. but you should be able to do something similar with your fiscal periods and metrics:

 

 

Jennifer_Dungan_1-1682020576257.png

 

 

Now.. this is obviously a simple example.. it is also currently locked to looking at three specific time frames... I am assuming you would potentially want to see this grow as you hit new periods.. or roll the last three periods?

 

So you might need to extend this to have some extra logic (possibly using IF functions).... 

Avatar

Level 1

Thanks for responding. I still cannot get it to work.

Avatar

Community Advisor

Would you be willing to share a screenshot of the combined calculated metric? Maybe there's a simple nesting issue?

Avatar

Level 1

I believe I figured it out. Now I want to take purchase quantity minus the monthly avg to get a pace.

 

Screen Shot 2023-04-25 at 10.59.48 AM.pngScreen Shot 2023-04-25 at 10.59.55 AM.png

Avatar

Community Advisor

That should work... I see that your average is all nested inside a container

 

Basically:

Purchase Quantity - [Container with Average Pace Calculation]

 

and your "Container with Average Pace Calculation" is: 

[Container adding all the individual calculations] / 3

page footer