How to show same activity in the same row(line) in Gantt Chart?
<p>Hi All,</p>
<p> </p>
<p>I am trying to create a Gantt chart to represent</p>
<p>Vehicle and its Actvity against time.</p>
<p>However I'm facing some issues in the representation.</p>
<p> </p>
<p>Sample data to play around is in mydata.csv file.</p>
<p>Contents of the file are as follows:</p>
<p>EntityID,EntityName,ParameterId,ParameterName,Start,End<br>
1,Vehicle 1,100,Activity1,1/1/2014,10/1/2014<br>
1,Vehicle 1,100,Activity2,12/1/2014,15/1/2014<br>
1,Vehicle 1,100,Activity1,20/1/2014,30/1/2014<br>
2,Vehicle 2,200,Activity2,15/1/2014,25/1/2014<br>
2,Vehicle 2,100,Activity1,26/1/2014,28/1/2014</p>
<p> </p>
<p>When I plot this data in a Gantt chart, For Vehicle 1; Activity 1 is repeated twice and hence Gantt chart displays it as a new row. See attached screenshot. However I want it to come in same line and legend should indicate the activity(parameter) name.</p>
<p>I have attached mydata.csv file, rptdesign file and screenshot for your reference.</p>
<p>Please let me know how can I achieve this.</p>
<p> </p>
<p>Thanks in advance.</p>
<p>Pooja.</p>
<p> </p>
<p>