5 Replies Latest reply: Jul 25, 2017 5:18 AM by venkatesswarlu dabbakuti RSS

    show currently opened records for last 4 months

    sahil bhatia

      Hi,

       

      I have data in this format:

       

      Problem ticketOpen DateClose DateStatus
      11/14/2015Open
      22/13/2016Open
      35/19/2016Open
      43/29/20175/22/2017Close
      56/8/2017Open

       

      I want to display currently opened records month wise in a bar chart in such a way that it only displays data of last 4 months including current month.

       

      So the output should be like:

      MonthProblem ticket
      Apr4
      May3
      Jun4
      Jul4

       

      thanks in advance