I have speed and consumption figures that I want to visualize in a graph. The speed should be on the x-axis and the consumption on the y-axis. The consumption should be the average consumption for a certain speed range. For instance the average consumption between 30 and 40 km/hour is 50 liters.
Currently I am creating a table with all speed ranges "hard coded", loop trough all "raw" datarows, recalculate the average consumption in a temp table (keep track of total and number of readings) and overwrite the results in the table (devide total by number of readings).
My question is if there is an easier way to approach this. I am using for instance the RadChart.
Best regards, MB