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

    Showing months with no data


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



      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?