3 Replies Latest reply on Mar 15, 2019 5:29 AM by LUCAS SARDO

    Line Chart and 'missing' value

    LUCAS SARDO

      Dear, I'm completely new to tableau and trying to design a simple line chart with Sales

       

      My data ource has the following data: (note that we have no info for MAY, yes, this product doesn't sell any unit on may)

       

      MonthSales
      JAN6.471
      FEB3.237
      MAR13.914
      APR2.961
      JUN9.105
      JUL6.183
      AUG1.683
      SEP4.221
      OCT1.221
      NOV3.678
      DEC4.104

       

       

      and my line chart on tableau is represented as attached image.

       

      Well, from my point of view, May should be represented as ZERO but looking the chart it gives the wrong impression that it sold around 4,5k , what's wrong.

       

      I've tried using ZN but it didn't work. How should I deal with it without changing the datasource ?

       

      thanks in advance.