Bar Chart with Closure %

[#1]

HI,

Had post teh query in another discussion group 5 days before and haven't received any reply.

Hence re posting in this group.

I am trying to create a bar chart with Interval as dimension and % of cases closed as line chart.

Below is sample data.

Created time Closed time Transaction Number

1:00 PM 1:15 PM Raj1

1:45 PM 2:30 PM Raj2

2:30 PM 2:45 PM Raj3

4:00 PM 4:30 PM Raj4

4:45 PM 5:30 PM Raj5

6:00 PM 6:15 PM Raj6

6:45 PM 7:00 PM Raj7

8:00 PM 9:00 PM Raj8

8:45 PM 9:05 PM Raj9

10:30 PM 11:00 PM Raj10

11:00 PM 11:35 PM Raj11

11:30 PM 11:45 PM Raj12

% % of closure is number of transaction closed at an interval basis of closed time  / Number of transactions created in same interval.

In teh above example for an Interval 1 Pm to 2 PM the % of closure is 50% ( 1 Closed / 2 Recieved)

[Anonymous]

Hi,

I'm studying your interesting problem.

Can you see the attachment?

(I added this row to check the correct behaviour of the expression: 6:00, 8:15, Raj13)

I'll wait for your feedback.

Elena

[maxgro · Accepted solution]

PFA