4 Replies Latest reply on Feb 13, 2016 11:40 AM by Patrick Walker

    Tableau - Dividing two calculated fields, getting incorrect result of 1

    Patrick Walker

      I've been ripping my hear out trying to figure out why this is happening, any help would be very much appreciated!

      I'm trying to divide the result of a calculated field by the result of another calculated field in order to get a percentage ("X% of transactions were at or below SLA" essentially). Not sure if the problem is how I'm calculating the two fields, or this new calculation I'm using.

      Here is the calculation I'm using: sum([CALC1]) / ([CALC2]) --I'm getting a result of 1 using this, but am expecting something like .982.

      CALC1: IF [Total Time (seconds)] > 180 THEN 1 ELSE 0 END
      CALC2: COUNT([Trans Id])