Ability to show column average instead of col. total in Workspace Analysis | Community
Skip to main content
jonasn28741159
jonasn28741159
Level 2
September 6, 2019
New

Ability to show column average instead of col. total in Workspace Analysis

  • September 6, 2019
  • 6 replies
  • 3831 views

Hi Team,

Presently, all the reports in Analytics/Workspace by default show 'sum total' of row items. It would be great if user has an option to change the default 'sum total' to different arithmetic calculations like average, weighted average etc. for all the metrics (custom, calculated and standard). At present if we want to see average, we may have to create a calculated metrics.

Thank you!

    6 replies

    jonasn28741159
    jonasn28741159Author
    Level 2
    September 6, 2019

    Attached screenshot for reference.

    A
    Andres_Olivares
    May 4, 2022

    I can't believe this still isn't an option

      C
      Caro_V
      November 15, 2023

      We also need this feature for analysis. How can this topic be pushed?

      A
      AntonPy
      December 6, 2023

      Yeah, would be great to have that easy solution. 

      But I can suggest several options depending on the needs that can be used:
      Use the cumulative average function to apply metric smoothing
      Reference: basic functions
      + 
      Easy and fast option that I use to get avg from column:
      Visualize --> Summary number --> Summarize value by --> Mean

       

      M
      Adobe Employee
      mwaikarAdobe Employee
      Adobe Employee
      February 5, 2024

      Thank you Anton

      M
      michaelana1
      February 7, 2024

      I used the summarize values by mean option that someone noted above, but I have filters on that aren't being accounted for. its giving me the mean of the column grand total, not filtered total. does anyone have fix?

      Terms & ConditionsAccessibility statement

      Loading footer...