working with multiple dates

[anuradhaa]

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

[sujeetsingh]

can you give the sample

[anuradhaa]

i have below two records

CanonicalDate	createdDate	Status	Priority	Involve Tech Team	Ticket Type	solveddate	DateType	Id
1/31/2013	1/31/2013	Closed	Normal	Yes	Valid Issue	2/5/2013	created	784
2/5/2013	1/31/2013	Closed	Normal	Yes	Valid Issue	2/5/2013	solve	784

and i want to merge them and get below single record based on id

Id	Status	Priority	Involve Tech Team	createdate	solveddate	[Ticket Type]
784	Closed	Normal	Yes	1/31/2013	2/5/2013	Valid Issue

[sujeetsingh]

Use group by when resident load

[anuradhaa]

pls use attached qvw

[sujeetsingh]

Anu ,

Please explain or write upin your sample that what do yo really want in it .

[anuradhaa]

Hi,

here i want to display ticket statistics. here a ticket has id, create date, slove date etc.

some tickets were created in feb and closed in march.

so as you can see i want a calendar to select months.

so when i select feb, it has to show all tickets close or solve in feb.

so i use canonical date and use that to display.

but when i do that it gives me two records, one for create and one for solve for same id.( you can see it in my table top)

i need to merge that. i use if condition and did it (below) but when i do that that is only show the tickets created in selected month. but i want to display created and solve. both.

hope this will help

thanks for your replys

[sujeetsingh]

See this it works fine to me

[anuradhaa]

no, take id 1436. it has two records. i want to get one record using these two records

[sujeetsingh · Accepted solution]

Anu,

This is happening just due to cronical date in dimension as their are values hence try using a valid logic for taking any one based on latest date .