4 Replies Latest reply on Dec 18, 2013 3:39 PM by Tracy Rodgers

    if contains statements

    Paul Ozule

      I have a dimension that logs successes or failures. And i want to create a measure of each (Success and Failure Counts) from this string. I tried creating a calculated field but not sure what is going on (IF CONTAINS ([RESULT], "success") THEN "Success" ELSE "" END). Here is a sample data.

       

      Failure-2DispIn90Or0-Transfer206
      Failure-AcctOverDue-Transfer625
      Success-AppointConfirmMenu738
      Success-ApptFoundReview1384
      Success-Balance Playback330
      Success-BalanceDown352
      Success-FAQ Copy Playback164
      Success-FileAClaimMenu570
      Success-General FAQ Playback388
      Success-GetDispatchByContract Module15247
      Success-Move to Balance Menu1830
      Failure-ValidateContractEntry-Balance-Transfer162
      Failure-ValidateContractEntry-Claims Status-Hang Up73
      Failure-ValidateContractEntry-Claims Status-Normal22
      Failure-ValidateContractEntry-Claims Status-Transfer170
      Failure-ValidateContractEntry-Contract Status-Transfer131
      Failure-ValidateContractEntry-Schedule a Repair-Hang Up441
      Failure-ValidateContractEntry-Schedule a Repair-Transfer1236
      Failure-ValidatePhone Entry-Balance-Hang Up208