2 Replies Latest reply on May 14, 2018 12:05 AM by Chris McClellan

    Showing months with no data

    yegor.tchitaev

      I have a set of rows by date where there are row entries where some months are missing:

       

      e.g.

      10 Nov-17 | 1

      2 Jan-18 | 1

      3 Jan-18 | 1

      12 Mar-18 | 1

      15 Mar-18 | 1

       

      My intent is to e.g. show a count (even 0) for each of the past 12 months.

       

      However when I chart this I only see values for the months I have values and those in between, i.e. Nov-17 through to Mar-18 but not months after or before.

       

      I've tried ZN(), show missing values, ISNULL(). Is there any simple way to do this?

       

      Thanks.