1 Reply Latest reply on Nov 5, 2018 10:49 AM by Yuriy Fal

    Calculating efficiency KPI using different measure values (on same measure)

    Kenneth Hansen

      Hi

       

      I am trying to create a calculation that gives me produced square metres (for finished goods) per man hour paid per Plant.

       

      The setup is that we have a MachineNumber dimension and an AreaOut measure. My issue is that machines work in sequence - meaning that e.g. machine X feed to machine Y etc. So each machine have an AreaProduced measure but I only want to include AreaOut of the machines that are last in the production sequence (finished goods - 4 out of appr. 50 machines) in the calculation. However I want to include the ManhoursPaid on all machines to get a Plant efficiency KPI.

       

      Any ideas on how to achieve this?

      (I am using Tableau 2018.2)

       

      Kenneth