Forum Discussion

MEFOX's avatar
MEFOX
Icon for Helper III rankHelper III
4 years ago

Total incorrect

I'm using the table visual. I've turned on Totals in the Format section and I get a Total that is incorrect. The Total should be 584. Can someone give me some ideas of what might cause this. Is there...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

MEFOX 

You need to use something other than DISTINCTCOUNT because it is giving you the correct answer, the same Contact ID is in several days so in the total each DISTCINT countact id only gets counted once .  You should us COUNTROWS.

  • MEFOX's avatar
    MEFOX
    Icon for Helper III rankHelper III
    4 years ago

    Unfortunately I'm not having much luck with the COUNTROWS function. Are you aware of another visual (maybe a marketplace visual) that might sum the rows in the visual instead of the data behind the visual?