Skip to main content
Solved

AVG by one dimension

  • Jun 16, 2023 8:34 AM UTC
  • 2 replies
  • 782 views
Wallflower

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? 

Best answer by Franck C

Hey, 

 

From what I understand, you could try

[remove avg: ‘CohortMonth’]

That ok ?

Franck

View original

    2 replies

    Franck C
    Employee
    Forum|alt.badge.img+4
    • Franck CEmployee
    • Employee
    • Answer
    • Jun 16, 2023 8:36 AM UTC

    Hey, 

     

    From what I understand, you could try

    [remove avg: ‘CohortMonth’]

    That ok ?

    Franck

      Wallflower
      • lpaulWallflower
      • Author
      • Wallflower
      • Jun 16, 2023 9:36 AM UTC

      Appreciate it, thank you! Works like I imagined. 

        Ask your question here!

        Terms & ConditionsAccessibility statement