3 Replies Latest reply on Jan 7, 2019 11:53 PM by Sankar M

    failed to publish

    Seb Bec

      I am looking for some guideless on this issue.

      I have a Dimension ("Customer Name")

      What I want to do is get the total number of record (Customers) and
      multiply by 3

      This is what I have tried so far.

      1. create a calculation field
      2. Use formula      TOTAL(COUNTD([Customer Name]))*(3)
      3. drag CF to Rows and changed to Discrete

       

      This displays the correct number and works fine in the
      development tableau desktop; however, if I try to publish it, I get an error

      "could not find a total needed to compute a percentage.
      The database may have changed or a calculation cannot be completed"

      I am sure there is an easier way to do that, I am still
      learning...

       

      Any help is greatly appreciated