Calender for 3 DateTime fields

[#1]

Hi All,

I am struggling with my Data Model. Here I have 3 date fields in my table.

RequestTime, StartTime, EndTime.

I need assistance in how to create calendar out of these 3 fields?

I need to plot a chart with the analysis of

number of Requests Vs Number of Request Processed(Started).(per hour/day/Week/Month/Year)

Appreciate your assistance.

Thanks & Regards,

Poonam

[Anil_Babu_Samineni]

Use This. It will come like below

[dathathreya]

Hi poonam in your data the date field is same so far the time only changing so u can take any date.create a time bucket for the time.start and end.so by that u can plot the time interval.

[MarcoWedel]

maybe helpful:

Canonical Date

regards

Marco