Wrong data is getting calculated in chart

[ashis]

Hi ,

I have sample data like this .

in expression I wrote max(endtime) - min(starttime) ,when I plot a chart , it is considering all the rows (10 rows) data .

However I want to show only highlight data difference .

Please let me know where I am doing wrong.

[Anonymous]

May be you should use AGGR function to aggregate data on your key field.