I have a requirement to create a chart and need some help. Attached is the sample source data format and expected output format.
Cyclic group in chart should have values from hour , 30 minute interval , 15 minute interval , 1 minute interval .
Requirement is the bar in (color green) should extend based on the the time dimension.
For e.g if task 1 starts at 18th minute in one hour and it ends at 31th minute in next hour , green colored bar should extend till the end time stamp. or it should start and end in the relevant 15 or 30 minute interval slot.
