Skip to main content

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? 

Hey, 

 

From what I understand, you could try

eremove avg: ‘CohortMonth’]

That ok ?

Franck


Appreciate it, thank you! Works like I imagined. 


Reply