<p>Hi,</p>
<p>I would like to have a line chart with an overview of time periods grouped by months. I have a dataset with columns (startdate(DATETIME), enddate(DATETIME), time period desc(DATETIME), value(FLOAT), indx name (string)).</p>
<p>Taking the time period desc in x-axis (as month data) and the value in y-axis and optional grouping as indx name. The x-axis should get grouped in order to display all the data points between each Time period.</p>
<p> </p>
<p>for example,<br>
If the user selects a 05/31/16 startdate and to plot 5 Years TP, the axis should like (please check the attachment<strong> plot1</strong>)</p>
<p> </p>
<p>the x-axis label would be,</p>
<p>05/16 05/15 05/14 05/13 05/12 05/11</p>
<p> </p>
<p>In-between 05/16 to 05/15 we have 12 data points..so we need to show the 12 data points without x-axis TP (04/16, 03/16,02/16,01/16,12/15,11/15,10/15,09/15,08/15,07/15,06/15).</p>
<p> </p>
<p>Please see the attachment <strong>Plot2 </strong>for reference. Can anyone please help me out in grouping the x-axis label as per the expectations.</p>
