Hi,
I am trying to find a quick way to get an AVG of 1 out 4 dimensions in the metric and use it for the further calculations. I have data based on cohort, with Cohort Month (on rows) and Cohort Age (on collumns). I would like to take and avg of cohort months and only have Cohort Age Dimension in.
I was trying AVGOF formula with exclude modifier but that did not work. Also, BY AVG: CohortMonth, but that keeps the metric in. Any suggestions?
AVG by one dimension
![Top Modeler Q2 '23 Badge](https://uploads-eu-west-1.insided.com/pigment-en/attachment/9a0e1193-fe12-4cf3-8c35-c562d46aeed3_thumb.png)
Appreciate it, thank you! Works like I imagined.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.