Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my data set i'm using createdate and solve date. when the user select date in list box i need to show all the data in that date (both solve and create)
some tickets create in jan and close in feb. so i need to display that when he select jan. or feb.
i did it using canonical date and put date time field based on create or solve.
now i want to merge below two records and display one record.
Created date/status/priority/ticket type /Solve date
here this data set should satisfy above condition in data setection.
Thanks
CanonicalDate | createdDate | Status | Priority | Involve Tech Team | Ticket Type | solveddate | DateType | Id |
3/17/2014 | 3/17/2014 | Solved | Urgent | No | Valid Issue | 3/17/2014 | created | 1521 |
3/17/2014 | 3/17/2014 | Solved | Urgent | No | Valid Issue | 3/17/2014 | solve | 1521 |
it works . thank you
You are welcome