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

    Convert Script to tableau formula

    Stephen Cavallaro

      Hello,

       

      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:

           

          SUM(

            {FIXED [Case ID] : MAX(

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

              THEN 0

              ELSE 1

              END)}

          ) * 100

          /

          COUNTD([Case ID])

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

           

          Yours,

          Yuri