13 Replies Latest reply on Dec 11, 2017 1:54 PM by Abhishek Belnekar

    Custom Date filter that can show last 12 months in Month and Year format in drop down

    Abhishek Belnekar

      Hello,

       

      I want to create a custom filter around a datetime dimension which can show 12 months including current month in month-year format. The dimension that I have used brings only few dates based on availability of the data as below

       

      March-2017

      Jun-2017

      August-2017

      November-2017

       

      What I want is it should show the missing months as well

       

      January-2017

      February-2017

      April-2017

      May-2017

      July-2017

      September-2017

      October-2017

      December-2017

       

      with this I would be able to generate a blank report based on customer requirement.

       

      Any idea around this will be helpful.