Hello everyone,  I got stuck with the following query, can you please check and do the needful. Thanks in advance!   This is what I have Subject Category Start End 101 Period1 7-Aug-24 24-Aug-24 101 Period2 12-Aug-24 14-Aug-24 101 Period3 25-Aug-24 27-Nov-24 101 Period2 27-Aug-24 27-Aug-24 101 Period4 11-Sep-24 27-Nov-24 101 Period2 20-Sep-24 20-Sep-24 101 Period2 13-Oct-24 16-Oct-24 101 Period2 20-Oct-24 22-Oct-24 101 Period2 7-Nov-24 8-Nov-24   I want the result in the below fashion. Please do the needful Subject Category Start End   101 Period1 7-Aug-24 11-Aug-24   101 Period2 12-Aug-24 14-Aug-24   101 Period1 15-Aug-24 24-Aug-24 Since this continued from 7Aug till 24Aug in between Period 2 occurred 101 Period3 25-Aug-24 26-Aug-24   101 PEriod2 27-Aug-24 27-Aug-24   101 Period4 11-Sep-24 19-Sep-24   101 Period2 20-Sep-24 20-Sep-24   101 Period4 21-Sep-24 12-Oct-24   101 Period2 13-Oct-24 16-Oct-24   101 Period4 17-Oct-24 19-Oct-24   101 Period2 20-Oct-24 22-Oct-24   101 Period4 23-Oct-24 6-Nov-24   101 Period2 7-Nov-24 8-Nov-24   101 Period4 9-Nov-24 27-Nov-24 Period4 started 11-sep and ended 27Nov   ... View more

Hi, I am trying to get the histogram with density overlayed for the counts on Y axis and time on X-axis. However somehow, I am not able to get the density curve close to the histogram. Is density by default take the percent into consideration to plot the curve? Can you please help me on this?   x Y 1 830 2 155 3 65 4 45 5 52 6 35 7 20 8 15 9 10 10 5 ... View more