Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Union of two fields in same table

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

1 Reply
sunny_talwar

Look here on how to handle this situation:

Canonical Date