3 Replies Latest reply on Jun 21, 2016 11:03 PM by Lian Norliansyah

    Calculate % difference of two members

    Lian Norliansyah

      Hi,

       

      I would like to calculate % ticket delivered on time based on the following example below:

      in which it should be calculated as "Ticket Delivered On Time" / "Total Ticket" = 90% (based on the sample below)

       

      DateGroupL1 TeamL2 TeamGroup TypeBUServiceMetric NameValue
      1/05/2016Group A1Team ATeam AAPrimaryNo BUNo ServiceTotal Ticket10
      1/05/2016Group A1Team ATeam AAPrimaryNo BUNo ServiceTicket Delivered On Time9

       

      I need help how can this be achieved in Tableau.

       

      I can achieve the result by using table calculation:

      - Calculation Type: Percent From

      - Calculate the percentage along: Metric Name

      - Display the value as a percentage of: Next

       

      Then I hide one of the Metric.

       

      (see attached example)

       

      However, I would like to use a calculation within Tableau, which will give a greater flexibility in the presentation of the data.

      If the data source is OLAP, I can calculate using MDX, however, the source is SQL server table.

       

      Your help is appreciated.

       

      Thanks,

       

      Lian