Bar Chart with Closure %

Wed, 29 Jul 2015 12:37:54 GMT

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)

Re: Bar Chart with Closure %

Anonymous — Sun, 09 Aug 2015 11:44:38 GMT

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 — Sun, 09 Aug 2015 17:01:17 GMT

PFA