How do I add a total to a column when I added a Beast Mode?

kim_barragan0126
kim_barragan0126 Member
in Beast Mode

I added a Beast Mode so I would only get the Fee to list once since the Position ID is listed multiple times. I need to see each line so I can have a count on how many candidates per position. have I used - SUM(DISTINCT Fee). It works great, but how do I now get a total for the column?

Raw Data

image.png

This is the pivot. Everything looks great except the Grand Total. I want the "Test Fee" to have a correct Grand Total. Can this be done?

image.png

Best Answers

  • Craig_Lynch
    Craig_Lynch Contributor
    Answer ✓

    Hi Kim,

    Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.

    By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.

  • Ajeet Mahajan
    Ajeet Mahajan Domo Employee
    Answer ✓

    Thanks for reaching out to our community forum.

    In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure.

    Here are the common approaches to achieve this:

    1. Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
    2. Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.

    image.png

Answers

  • Craig_Lynch
    Craig_Lynch Contributor
    Answer ✓

    Hi Kim,

    Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.

    By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.

  • Ajeet Mahajan
    Ajeet Mahajan Domo Employee
    Answer ✓

    Thanks for reaching out to our community forum.

    In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure.

    Here are the common approaches to achieve this:

    1. Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
    2. Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.

    image.png

  • kim_barragan0126
    kim_barragan0126 Member

    Thank you for the responses! I was able to create the below Beast Mode which solved my issue.

    SUM(MAX(Fee) FIXED (by Position ID))

  • Ajeet Mahajan
    Ajeet Mahajan Domo Employee

    Great!

    I apologize for the misunderstanding. It seems I misinterpreted your use case. I thought you wanted to display a unique row for each position ID with its corresponding fee, along with a grand total for the overall fees.

    I'm glad you were able to find a solution that works for you!

Categories