5 Replies Latest reply on Dec 12, 2016 9:33 AM by Mark Smith

    LOD Question - % of days affected

    Mark Smith

      Hi

       

      I have a problem that I am trying to solve using an LOD expression. I'm not sure it is possible without implementing some sort of ranking at data source level.

       

      The problem is to create a flag which highlights a stock based on the lead time of 'holds'. So, if the average lead time when 50% of available days had been 'held' is > say, 100 days, then flag the stock.

       

      I attach a sample workbook, my initial feeling is that this can't be done in tableau using and LOD expression?

       

      Thoughts?

       

      Thanks

       

      Mark