2 Replies Latest reply on Jan 30, 2019 5:21 AM by Kristian Strub

    Running Percent of Total Exceeds 100%

    Kristian Strub

      Hello,

       

      I'm trying to get a running percent of total line but the values are a bit off, exceeding 100%. I've already run across the Tableau knowledge base on this here: https://kb.tableau.com/articles/issue/percent-of-total-adds-up-to-more-than-100

       

      I've tried both options, dragging the table calc to the measures pane and replacing "TOTAL" with "WINDOW_SUM" or using an LOD both give me the same result as the basic table calc. The root cause as described in the KB article is confirmed to my situation though, as I am using a COUNTD value to run this calculation. I'm sure I am missing something really silly...

       

      Any tips? My table calc is below, working off an aggregate distinct count measure.