<p>Hi,</p>
<p> </p>
<p>I have a set of records with ids and an average of time.</p>
<p> </p>
<p>Average of time was built with the expression builder to calculate difference between dates to see how long it took and then creating another aggregation which averages them out.</p>
<p> </p>
<p>The problem is that all my ids have the same number on the average and my Id are duplicates because there is history with these records.</p>
<p> </p>
<p>I want to show the Id only 1 time on chart and show the average of age for that Id but I get the id multiple times. In the table you can do a suppress duplicate values but I cant find it on the CHARTs.</p>
<p> </p>
<p>Example</p>
<p> </p>
<p>Id Average</p>
<p> </p>
<p>100 11</p>
<p>100 11</p>
<p>100 11</p>
<p>103 11</p>
<p>103 11</p>
<p> </p>
<p> </p>
<p> </p>
<p>Any thoughts?</p>
<p> </p>
<p>Thank you so much,</p>
<p>RR</p>
