4 Replies Latest reply: Feb 12, 2016 8:09 AM by Prashanth Reddy Nasi RSS

    How to fill missing months in data ?

    Prashanth Reddy Nasi

      Hi all,

       

      How can i fill the gaps in the Month column?

       

      Load

      Product  Month            Price

      A          01/01/2015         10

      A          02/01/2015          20

      A          05/01/2015          15

      A          06/01/2015          17

       

      When I bring this to bar chart how can I show all the months between minMonth and maxMonth.

      i.e, March and April as 0's.

      Without hard coding. Because I have some Many number of products. I came to know that it can be done using Master calendar.

      But I am not able to use that in this case. Please help me out.

       

      Thanks

      Prashanth.