2 Replies Latest reply on Oct 12, 2018 4:15 AM by Stephen Groff

    Showing Blank Values in View - Heatmaps

    Stephen Groff

      Anyone?

       

      Workbook attached.

       

      I'm trying to create a heatmap of specific value streams and I've exhausted my current knowledge as to how to fix this.  I want to show all production areas regardless of whether there is data, but as you can see from the pictures below... It won't let me.

       

      I've tried inputting ZN & IFNULL before my calculations so they return a value, but this does not help.  Anyone have some ideas?

       

      YEAR

       

      MONTH

      WEEK

      DAY

       

      Thank you in advance for your help.