Card Summary Number not Matching Running Total Number

Having an issue getting a running total line's last value (90) to match up with the same value in the Summary Number (83) despite using the same Beast Mode calculation for both.

 

Any thoughts as to why these wouldn't match up?

 

Sum Number.PNG

 

Overall Num.PNG

 

Beast Mode Calc.PNG

 

 

Best Answers

  • Godzilla
    Godzilla Contributor
    Answer ✓

    in the summary number properties(your first screenshot), change to the  'User Current Value' selection. You currently have it set to 'Use all values'. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • jmo
    jmo Domo Employee
    Answer ✓

    I think the first step would be to verify that you have duplicates across dates (it's just a hunch until that is confirmed).

     

    Assuming that is true, you won't be able to get the summary number to match exactly using a count distinct function.  You may have to run a data flow to correctly account for the fact that you are recycling some customers over time.

     

    Have you confirmed that it is ok to have duplicated customers like this? You might have uncovered a data quality issue.

    -----
    I work for Domo.
    **Say "Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as "Accepted Solution"

Answers

  • Godzilla
    Godzilla Contributor
    Answer ✓

    in the summary number properties(your first screenshot), change to the  'User Current Value' selection. You currently have it set to 'Use all values'. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • jamesd
    jamesd Member

    I thought it would be that simple that causes the summary value to change to just 1.00

  • Godzilla
    Godzilla Contributor

    How about the sort order, do you have the 'Last' option selected(as in screenshot below)? 

     

     

    Capture.JPG

     

    How about the sort order in the 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • jamesd
    jamesd Member

    Yeah it stays at 1 whether I choose first or last value.

  • swyatt
    swyatt Contributor

    Do you have more than one date field? Also, do you think the content of your "Active" filter would have any effect whatsoever? Just trying to get a better picture.

  • jmo
    jmo Domo Employee

    It's likely that you have at least one `Customer` that is repeated across the time periods. I'll use the following as an example.

     

    example

     

    If you're using a running total, this data would result in 4 for 6/21 and 8 for 6/22. However, the summary number will show 7 b/c customer 5 is repeated.

    -----
    I work for Domo.
    **Say "Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as "Accepted Solution"
  • jamesd
    jamesd Member

    Shouldn't using Count Distinct force it to only count each customer once, whether it's in the card or the summary number?

  • jmo
    jmo Domo Employee

    Yes, except that the query powering the card is grouping on the date. That means it will count the distinct users w/in each date. The summary number isn't grouping at all so it will count distinct across the entire set of customers.

    -----
    I work for Domo.
    **Say "Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as "Accepted Solution"
  • jamesd
    jamesd Member

    Is there a way to get the Summary Number to group on the date so that I can get these numbers to match?

  • jmo
    jmo Domo Employee
    Answer ✓

    I think the first step would be to verify that you have duplicates across dates (it's just a hunch until that is confirmed).

     

    Assuming that is true, you won't be able to get the summary number to match exactly using a count distinct function.  You may have to run a data flow to correctly account for the fact that you are recycling some customers over time.

     

    Have you confirmed that it is ok to have duplicated customers like this? You might have uncovered a data quality issue.

    -----
    I work for Domo.
    **Say "Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as "Accepted Solution"
  • kshah008
    kshah008 Contributor

    @jamesd, did any of the above replies help address your question?

This discussion has been closed.