Solved

AVG by one dimension

  • 16 June 2023
  • 2 replies
  • 82 views

Badge +1
  • Newly Minted Pigmenteer
  • 1 reply

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? 

icon

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

View original

2 replies

Userlevel 4
Badge +4

Hey, 

 

From what I understand, you could try

[remove avg: ‘CohortMonth’]

That ok ?

Franck

Badge +1

Appreciate it, thank you! Works like I imagined. 

Reply