AVG by one dimension

Badge +1
  • Newly Minted Pigmenteer
  • 1 reply


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? 


Best answer by Franck C 16 June 2023, 10:36

View original

2 replies

Userlevel 4
Badge +4



From what I understand, you could try

[remove avg: ‘CohortMonth’]

That ok ?


Badge +1

Appreciate it, thank you! Works like I imagined.