Total Rows not Calculating

Jarren
Jarren Member
in Cards, Dashboards, Stories

We have a drill path that ends with a table card. The table card has a total row but it doesn't display totals except for counts.

image (2).png

Tagged:

Best Answer

  • Jarren
    Jarren Member
    Answer ✓

    I found a solution to this issue. First - Huge shoutout to @DashboardDude who took time out of his busy schedule to meet with me and help me on my way to a solution.

    To simplify, I had a beast mode similar to SUM(Priced Items) / SUM(Pounds Shipped). @DashboardDude noticed there were several beast modes like this but SUM(Pounds Shipped) would be a 0 value at times. The beast then became:

    CASE WHEN SUM(Pounds Shipped) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END

    So we fixed that part but still couldn't get totals in the total row for some reason.

    Turns out if you have any NULL values in the column (in my case at least) DOMO isn't going to total those values. So the correct beast mode ended up looking like this:

    CASE WHEN IFNULL(SUM(Pounds Shipped),0) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END.

    Thanks again to everyone, especially @DashboardDude, for your help

Answers

  • ColemenWilson
    ColemenWilson Coach

    Double check that "Hide total" is not checked for those fields:

    Screenshot 2024-05-16 at 8.46.30 AM.png

    If I solved your problem, please select "yes" above

  • Jarren
    Jarren Member
    edited May 16

    @ColemenWilson Thanks for the reply. Those are unchecked but we still have the same issue. We also noticed this happening to our subtotals on another card…

    Screenshot 2024-05-16 085300.png

  • ColemenWilson
    ColemenWilson Coach

    So are there values in the cells above for those fields?

    If I solved your problem, please select "yes" above

  • Jarren
    Jarren Member
    edited May 16

    @ColemenWilson The green blocks contain data

  • Jarren
    Jarren Member

  • DashboardDude
    DashboardDude Coach

    @Jarren trying to also help here. Just want to confirm that the columns are numeric. When you add columns to the top of analyzer where it says columns are they green or blue? A screenshot would help too.

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • Jarren
    Jarren Member

    @DashboardDude I verified the fields are numeric, for the most part. Attached you'll find the screenshots you requested. Thank you in advance for your help

    Field Names.png
    Table.png

  • DashboardDude
    DashboardDude Coach

    @Jarren and can you share a screen shot of what Totals looks like under chart properties?

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • Jarren
    Jarren Member

    @DashboardDude

    Totals 1.png
    Totals 2.png

  • DashboardDude
    DashboardDude Coach

    @Jarren Thanks. Truthfully, this is a bit difficult to help without seeing context. I'm happy to give 30 min if you are free and willing to share your screen, but if not I hope you can figure out what's going on:

    Feel free to book 30 for tomorrow if you want to: https://www.dashboarddudes.com/domo-help

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • Jarren
    Jarren Member
    Answer ✓

    I found a solution to this issue. First - Huge shoutout to @DashboardDude who took time out of his busy schedule to meet with me and help me on my way to a solution.

    To simplify, I had a beast mode similar to SUM(Priced Items) / SUM(Pounds Shipped). @DashboardDude noticed there were several beast modes like this but SUM(Pounds Shipped) would be a 0 value at times. The beast then became:

    CASE WHEN SUM(Pounds Shipped) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END

    So we fixed that part but still couldn't get totals in the total row for some reason.

    Turns out if you have any NULL values in the column (in my case at least) DOMO isn't going to total those values. So the correct beast mode ended up looking like this:

    CASE WHEN IFNULL(SUM(Pounds Shipped),0) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END.

    Thanks again to everyone, especially @DashboardDude, for your help

  • DashboardDude
    DashboardDude Coach

    @Jarren Glad you figured it out!!

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

Categories