1 Reply Latest reply on Jun 13, 2016 1:44 PM by Yuriy Fal

    Convert Script to tableau formula

    Stephen Cavallaro



      I could I convert the following formula to a calculation in tableau?


      MAX(CASE WHEN "Assignment History"."Assigned To Group" LIKE '%NSC%' THEN 0 ELSE 1 END by "- EPM CB Incidents"."Case ID") *100 / COUNT(DISTINCT "- EPM CB Incidents"."Case ID"


      Thank you.

        • 1. Re: Convert Script to tableau formula
          Yuriy Fal

          Hi Stephen,


          Assuming you've got your [Assignment History] and [- EPM CB Incidents]

          tables/views joined somehow in a Tableau datasource, it could be something like this:



            {FIXED [Case ID] : MAX(

              IF CONTAINS([Assigned To Group], 'NSC')

              THEN 0

              ELSE 1


          ) * 100


          COUNTD([Case ID])

          Couldn't say more without looking at the data and a business case.