1 Reply Latest reply: Jul 14, 2017 7:48 AM by Sunny Talwar RSS

    Union of two fields in same table

    sahil bhatia

      Hi,

      I have 3 fields, Open Date , Close Date and Status.

      Open DateClose DateStatus
      1/15/2017Open
      2/20/20172/20/2017Close
      2/22/2017Open
      3/25/20173/26/2017Close
      3/26/20174/11/2017Close

       

      i want to show the month for union of (open date ,close date) fields in a list box using expressions.Please help me to achieve this.

       

      Desired Output:

      Month

      Jan

      Feb
      Mar
      Apr

       

      So that, if i click on "Feb",it displays 1 Open ticket and 1 close ticket in chart.

       

      thanks