HI,
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 by created time
