4 Replies Latest reply on Oct 19, 2016 5:14 PM by Jatin Kakani

    Calculation keeping one parameter constant - LOD Expression

    Jatin Kakani

      Hi guys,

       

      I have an expression for yield calculation as yield = completed/completed+scrapped.

      Now I have different views for showing the yield like for example, yield by product group.

      What I want is for every product group, just the numerator i.e. number of completed lots should change however the denominator should remain constant i.e. total count of completed and scrapped lots for all the product groups.

      Normally if I fetch the product group dimension to the pane and do the calculation, what happens is Tableau first filters out all the lots based on product group and then performs the calculation.
      However, in my case the denominator needs to remain constant.

       

      I tried to use the LOD expression FIXED for the denominator, however Tableau doesn't allow me to do so saying aggregated and no aggregated functions cannot be used together.

       

      Please help me with the same.

       

      Thanks.

      Regards,

      Jatin