Can "Total Row" sum the column contents when those columns are using aggregation = Average

Roman_K
Roman_K Member
in Cards, Dashboards, Stories

I have 5 columns where I am using aggregation = Average, and when I include "Total Row", the total values are also averages. Is there a way to change the "Total Row" settings so that those columns are summed, not averaged?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You should be able to get around this by using fixed functions. Here's an example:

    Beast Mode:
    SUM(AVG(revenue) FIXED (BY sales_rep))

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • ArborRose
    ArborRose Coach

    I believe the total row at the bottom will give the same aggregation as you have above. You could create two versions of the column, a second one for sum. Pivot tables would give more flexibility for creating custom aggregations.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You should be able to get around this by using fixed functions. Here's an example:

    Beast Mode:
    SUM(AVG(revenue) FIXED (BY sales_rep))

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Roman_K
    Roman_K Member

    Implemented the logic below successfully.

    SUM(AVG(revenue) FIXED (BY sales_rep))

Categories