<div>
What is the underlying datasource (Oracle, SQL Server, MySql, ...)?
</div>


<div>
The underlying datasource is MS SQL 2008 Express Edition.
</div>


<div>
Ok, now do you know how to create a histogram with RadChart? &nbsp;Or, are you looking for how to use RadChart, instead of creating a temporary table?<br />

</div>


<div>
First, I have not created a histogram with a RadChart before. I am just getting used to this control.<br />
<br />
Below the description of my problem. I have a table with readings, somewhat summarized as below:<br />
vessel | speed | consumption | wind force | sea state | ballast<br />
&nbsp; xxx &nbsp; | &nbsp; &nbsp; 20 &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; 18 &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8 &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp;500<br />
&nbsp; yyy &nbsp; | &nbsp; &nbsp; 21 &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp;18.5 &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp;200<br />
&nbsp; etc<br />
<br />
In the histogram I need to show the average speed belonging to a speedrange with a certain filter. For instance calculate the average of all speeds between 20.5 and 21.5 for the records were the windforce was &lt;&nbsp;5. The user should be able to change the filters so the calculation should preferably take less then a minute.<br />
<br />
I assumed the above was not possible with a RadGrid and I needed to make a temp table everytime the used changed the selections.<br />
<br />
Regards MB
</div>


<div>
What do you want along the x-axis for the steps? &nbsp;What is the scaling going to be?
</div>


<div>
The speed on the x-as is from 15 to 25 knots (all other data must be ignored) with steps of 1 knot. I then need to calculate the average of all records that fall within this this speed range and are for instance:<br />
- only loaded vessel<br />
- less then windforce 5<br />
- ballast smaller then 200
</div>


<div>
Is this the current version for R.A.D. Chart? &nbsp;ASP.NET or WinForms?
</div>


<div>
I will use ASP.NET and it is version 2008 Q2, but I can upgrade to Q3.
</div>


<div>
Q2 should be OK. &nbsp;For a histogram, you would need a horizontal bar chart type, which is the default when you add a &nbsp;RadChart to the page. &nbsp;Are you binding the RadChart to an SqlDataSource, or something else?<br />
<br />
<br />

</div>


<div>
I am binding to a datatable from a sql datasource. Looking at the radChart types the horizontal bar chart seems to be the one I need. How do I now prepare the data best?
</div>


<div>
Calculating averages in a query is pretty easy. &nbsp;Are you using a stored procedure, or something similar? &nbsp;What is your data source for the SqlDataSource (SQL Server, Oracle, Access, ...)?
</div>


<div>
Thanks again,<br />
<br />
The datasource is MS SQL 2008 Express.<br />
<br />
Using datatables I would need something like this:<br />
Protected Sub GraphSpeedAndConsumption()<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim TempTable As New DataTable<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim AllValuesTable As New DataTable<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim ColumnSpeedRange As New DataColumn(&quot;SpeedRange&quot;, GetType(String))<br />
&nbsp; &nbsp; &nbsp; &nbsp; TempTable.Columns.Add(Colu<wbr />mnSpeedRan<wbr />ge)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim ColumnConsumption As New DataColumn(&quot;Consumption&quot;, GetType(Integer))<br />
&nbsp; &nbsp; &nbsp; &nbsp; TempTable.Columns.Add(Colu<wbr />mnConsumpt<wbr />ion)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; For i = 0 To 15<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TempTable.Rows(i).Item(&quot;Sp<wbr />eedRange&quot;)<wbr /> = i + 15 &amp;&nbsp;&quot; - &quot;&nbsp;&amp; i + 15 + 1<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TempTable.Rows(i).Item(&quot;Co<wbr />nsumption&quot;<wbr />) = AllValuesTable.Compute(&quot;Av<wbr />erage(Term<wbr />inal)&quot;, &quot;(Speed&gt;='&quot; &amp;&nbsp;i + 15 &amp;&nbsp;&quot;' AND (Speed&lt;'&quot; &amp;&nbsp;i + 15 + 1 &amp;&nbsp;&quot;' AND (CargoType='Loaded'&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Next<br />
&nbsp; &nbsp; End Sub<br />
<br />
However this requires me to fill the AllValuesTable and this is what I am trying to prevent to minimize the calculation time. Since you mentioned that calculating the averages is pretty easy I hope you can help me with a SQL query that works directly in the SQL datasource.<br />
<br />
Regards, MB
</div>


<div>
1) I answer so many questions, I get confused about what I already asked sometimes (sorry).<br />
<br />
2) Can you show me the SQL Server query, please?
</div>


<div>
Hi,<br />
<br />
Based on the information you have given me, getting the correct SQL server query is my question.<br />
<br />
Regards, MB
</div>


<div>
Then, can you please answer my question #2?
</div>


<div>
Thanks for the reply,<br />
<br />
Currently I fill a DataTable with the following SQL query SELECT * FROM SpeedConsumption. The columns contain speed, consumption, wind force, sea state, cargo type, etc. Then I use the code shown earlier to create a temp DataTable with speed ranges and average consumption. This will be used for the RadChart. But this method is not fast and I am looking for a faster SQL query.<br />
<br />
So I do not have a more advanced SQL Server Query. The question therefore is: can you point me in the right direction regarding a SQL query that returns a table with two columns:<br />
1. One with speedranges<br />
2. With average consumption<br />
Using a filter on for instance the column wind force.<br />
<br />
Regards, MB
</div>


<div>
Attempt #1:<br />
<br />
SELECT speed, consumption, windforce, cargotype, ballast, AVG(consumption) AS averageconsumption<br />
&nbsp; &nbsp; FROM SpeedConsumption<br />
&nbsp; &nbsp; WHERE (speed BETWEEN 15 AND 25) AND (windforce &lt;&nbsp;5) AND (ballast &lt;&nbsp;200)
</div>


<div>
Thanks again,<br />
I use MS SQL Management Studio to test the query and I get the following message:<br />
Column 'VESSELREPORTING.dbo.AtSea<wbr />Reports.Av<wbr />gSpeed' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.<br />
<br />
Using the query below<br />
SELECT [Avgspeed],[MEConsumption]<wbr />, [Wind], [CargoType], AVG([MEconsumption]) AS AverageConsumption <br />
FROM [VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([Avgspeed] BETWEEN 15 AND 25) AND ([MEConsumption] &lt;&nbsp;5) AND ([AvgSpeed] &lt;&nbsp;200)<br />
<br />
Regards, MB
</div>


<div>
Attempt #2:<br />
<br />
SELECT [Avgspeed],[MEConsumption]<wbr />, [Wind], [CargoType], AVG([MEconsumption]) AS AverageConsumption <br />
FROM [VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([Avgspeed] BETWEEN 15 AND 25) AND ([MEConsumption] &lt;&nbsp;5) AND ([AvgSpeed] &lt;&nbsp;200)<br />
GROUP BY [Avgspeed],[MEConsumption]<wbr />, [Wind], [CargoType]<br />
<br />
You need a GROUP BY clause with AVG, MAX, MIN, or any aggregate function (that'll teach me to code in the comment block).
</div>


<div>
Thanks a lot,<br />
Please ignore my limited knowlegde on SQL, but this is a fast and very good lesson.<br />
<br />
I almost have what I want. Now the average is calculated for an exact speed, so for instance for 15.0, 15.1, 15.2, etc. How can I get the average for all records with a speed between 15 and 16?<br />
<br />
Regards, Mark<br />

</div>


<div>
Are you talking about [AvgSpeed] in this criteria?<br />
<br />
&nbsp; &nbsp; &nbsp;([Avgspeed] BETWEEN 15 AND 25<br />
<br />
to<br />
<br />
&nbsp; &nbsp; &nbsp;([Avgspeed] BETWEEN 15 AND 16<br />

</div>


<div>
Thanks LearnedOne,<br />
<br />
I made some small changes to the query and it looks like this now:<br />
SELECT [Vessel] ,[Avgspeed] ,[MEConsumption], [Wind], [CargoType], AVG([MEconsumption]) AS AverageConsumption <br />
FROM [VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([Avgspeed] BETWEEN 15 AND 25) AND ([MEConsumption] &gt;&nbsp;5) AND ([CargoType] = 'Frozen Cargo')<br />
GROUP BY [Vessel], [Avgspeed],[MEConsumption]<wbr />, [Wind], [CargoType]<br />
<br />
The result is shown below, but what I need is that for each vessel there are 10 rows (15-16 knots, 16-17 knots, 17-18 knots, 18-19 knots, etc) and each row is showing the average consumption for all records that are withing the speed range.<br />
<br />
Alternatively it would be good if I get 1 row returned that but again for a speedrange and I use a loop to calling a stored procedure to get the results for multiple speedranges. <br />
<br />
Hope I explained it correctly.<br />
<br />
Regards, Mark<br />
<br />
Vessel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Avgspeed &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MEConsumption &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Wind &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CargoType &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AverageConsumption<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNW - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.69<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SSW - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NE - 6 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 2 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SE - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.20<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.5<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20.6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20.60000<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SSW - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14.10000<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.799999<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.200000<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SE - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNW - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.799999<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WNW - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESE - 3 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NNE - 5 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.200000<br />
Green Concordia &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WSW - 4 B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frozen Cargo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15<br />
<br />
<br />
<br />
<br />

</div>


<div>
That sounds like you are trying to categorize the data, but the categories would overlap if they are inclusive, since a 16 couldn't be in the 15-16 group and the 16-17 group at the same time.
</div>


<div>
What I mean is &gt;15 and &lt;=16, but how can I categorize using an SQL query?
</div>


<div>
Good morning,<br />
Trying different queries I still can not get to the desired result. I simplified the query somewhat to get to the real problem.<br />
SELECT [AvgSpeed], AVG([MECOnsumption]) AS AverageConsumption<br />
FROM [VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([AvgSpeed] BETWEEN 14 AND 18) AND ([Cargotype]='Frozen Cargo') AND ([Vessel] = 'Green Concordia')<br />
GROUP BY [AvgSpeed]<br />
<br />
The result of this query is shown below, and clearly shows my problem. I do not want records for 14, 14.1, 14.2, 14,4, 14.8, etc, but one record showing 14 and the average of consumption of all record between 14 and 14.9999. The next record should show 15 and the average of consumption of all records between 15 to 15.9999.<br />
<br />
Hopefully you can help me with this last step. Regards, MB<br />
<br />
AvgSpeed &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AverageConsumption<br />
14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.7999992370605<br />
14.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.8999996185303<br />
14.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12<br />
14.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19.5<br />
14.8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.75<br />
14.9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.3333330154419<br />
15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.0666666030884<br />
15.1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
15.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17.7333335876465<br />
15.3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16.5<br />
15.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19.0500001907349<br />
15.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.9666665395101<br />
15.7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.2000007629395<br />
15.8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19<br />
15.9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.7999992370605<br />
16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17<br />
16.2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18.2000007629395<br />
16.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15
</div>


<div>
Hi LearnedOne,<br />
Thanks again for your help. I was able to create the view and with a small adjustment to the query (it would not execute as it is shown) I got however the same result as before. Below the query and result.<br />
<br />
To make it easier (for me). Is it possible to let the SQL query return a single value? I only need the average of all consumptions that are withing a certain speed range.<br />
<br />
Using a stored procedure with parameters (which I now how to implement) I could loop through through speedranges and get the average of each speedrange this way.<br />
<br />
How can the query below give me that single value? (is it possible to include the case in this statement)<br />
<br />
SELECT [AvgSpeed], AVG([MECOnsumption]) AS AverageConsumption,<br />
&nbsp; &nbsp;FROM [VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
&nbsp; &nbsp;WHERE ([AvgSpeed] BETWEEN 14 AND 18) AND ([Cargotype]='Frozen Cargo') AND ([Vessel] = 'Green Concordia')<br />
&nbsp; &nbsp;GROUP BY [AvgSpeed]<br />
<br />
Thanks for bearing with me,<br />
Regards, Mark
</div>


<div>
Hi LearnedOne,<br />
<br />
Ignore my previous remark. I solved my problem as follows (probably not a method you would approve) but it works:<br />
I created the following stored procedure:<br />
<br />
SELECT AVG([MECOnsumption])<br />
FROM &nbsp;[VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([AvgSpeed] &gt;= @LowerBound) AND ([AvgSpeed] &lt;&nbsp;@UpperBound) AND ([Cargotype]=@CargoType) AND ([Vessel] = @Vessel)<br />
<br />
The stored procedure gives me a single value representing the average consumption of all values in a speedrange and other conditions.<br />
<br />
To get a datatable I use a loop in VB that calls this stored procedure for every speedrange.<br />
<br />
Regards, Mark
</div>


<div>
I believe I am at the final step, but once more I need your assistence.<br />
<br />
I have a stored procedure as shown below. I defined one output variable.<br />
<br />
ALTER PROCEDURE [dbo].[SP_AverageConsumpti<wbr />on]<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@LowerBound real, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@UpperBound real,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@CargoType varchar(50),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@Vessel varchar(50),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@AverageConsumption real OUTPUT <br />
AS<br />
BEGIN<br />
SET NOCOUNT ON;<br />
SELECT @AverageConsumption &nbsp;= AVG([MECOnsumption])<br />
FROM &nbsp;[VESSELREPORTING].[dbo].[A<wbr />tSeaReport<wbr />s]<br />
WHERE ([AvgSpeed] &gt;= @LowerBound) AND ([AvgSpeed] &lt;&nbsp;@UpperBound) AND ([Cargotype]=@CargoType) AND ([Vessel] = @Vessel)<br />
END<br />
<br />
The query returns the correct value in SQL. Now I need to get the value in VB. I use the following code but it always returns 0 and not the average I see in SQL.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'TEST RETURNING VALUE FROM STORED PROCEDURE<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim SQLCommandTemp As SqlCommand<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'Variables<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim LowerBound As Double = 15<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim UpperBound As Double = 16<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim CargoType As String = &quot;Frozen Cargo&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim Vessel As String = &quot;Green Concordia&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim Result As Double = 100<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp = New SqlCommand(&quot;SP_AverageCons<wbr />umption&quot;, Connection)<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.CommandType<wbr /> = CommandType.StoredProcedur<wbr />e<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.Parameters.<wbr />Add(&quot;@Lowe<wbr />rBound&quot;, SqlDbType.Real).Value = LowerBound<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.Parameters.<wbr />Add(&quot;@Uppe<wbr />rBound&quot;, SqlDbType.Real).Value = UpperBound<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.Parameters.<wbr />Add(&quot;@Carg<wbr />oType&quot;, SqlDbType.VarChar).Value = CargoType<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.Parameters.<wbr />Add(&quot;@Vess<wbr />el&quot;, SqlDbType.VarChar).Value = Vessel<br />
&nbsp; &nbsp; &nbsp; &nbsp; SQLCommandTemp.Parameters.<wbr />Add(&quot;@Aver<wbr />ageConsump<wbr />tion&quot;, SqlDbType.Real).Direction = ParameterDirection.Output<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Connection.Open()<br />
&nbsp; &nbsp; &nbsp; &nbsp; Result = SQLCommandTemp.Parameters(<wbr />&quot;@AverageC<wbr />onsumption<wbr />&quot;).Value<br />
&nbsp; &nbsp; &nbsp; &nbsp; Connection.Close()<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; If Result = 100 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debug.WriteLine(&quot;error&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debug.WriteLine(Result)<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'END TEST RETURNING VALUE FROM STORED PROCEDURE
</div>


<div>
Thanks a lot TheLearnedOne, I finally got it to work.
</div>


<div>
I approve of anything that you approve of. &nbsp;I don't try to force my thinking on other people. &nbsp;I try to present ideas, and let the other person assimilate that into their thinking, and then it isn't forced, but accepted.
</div>


<div>
Don't get me wrong with this remark, because like earlier you helped me a lot. Thanks again!
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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.<br />
<br />
Currently I am creating a table with all speed ranges &quot;hard coded&quot;, loop trough all &quot;raw&quot; 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).<br />
<br />
My question is if there is an easier way to approach this. I am using for instance the RadChart.<br />
<br />
Best regards, MB
</div>
</div>


Hi Experts,

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

Histogram chart

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,