2 Replies Latest reply: Aug 9, 2015 1:01 PM by Massimo Grossi RSS

    Bar Chart with Closure %

      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)