2 Replies Latest reply on Jul 31, 2018 3:12 AM by kumar bharat

    LOD/ Aggregations at different levels?

    Hannah Keith

      Hi,

       

      I've been stuck on this one for awhile, so I'm hoping you all can help me with a solve!

       

      I'm trying to show production (CPD) against planned production (Planned CPD). The lowest level of detail in the plan dataset is asset name and month while the actual dataset goes to asset name, day, and material. Product B only has 1 material, so SUM(Planned CPD)/7 produces the correct result (below). However Product A, C, and D can have multiple materials running on an asset at a time, resulting in duplications of some days of planned CPD.

       

      How can I adjust the Planned CPD calc to only look at 1 Planned CPD rate per asset instead of summing them all up?

       

      Ideally I'd take a sum of the median by line, but unfortunately haven't found a workaround for the 'can't take a aggregate of an aggregate' constraint

       

      Appreciate any help!

       

      Hannah

       

      Product B (what I'm trying to get A, C and D to look like)

       

      Product A - orange plan line should be fairly flat (similar to product B) rather than duplicating every time 2 materials are running at once

       

       

      This is what I'd like Product A to look like. I aggregated in excel to get this result but am trying to find a way to replicate the aggregation in Tableau