Good day everybody,
Nice to be in this forum, hope I find help for my problem in ASP.NET/T-SQL.
Because I can't create trend-lines with average of last 2 points in MSChart, I need to build a query that can do it. That's because my (power consumption) chart is fluctuating to fast to get a nice curve.
So I got this table and need this extra avg-column in my view/query.
That average column displays the average of the current and previous value.
id time c avg
1 10:00 4 4 (first record)
2 10:05 6 5
3 10:10 3 4,5
4 10:15 7 5
5 10:20 8 7,5
6 10:25 2 5
7 10:30 4 3
That average column would come in my chart time-average.
It would be usefull to be able to set the averaging number (in this case 2). But thats details...
It's also possible to run a stored procedure over the table, don't now whats easiest.
I tried and searched the web but found nothing
Who can take this challange?
Thanx in advance! Greetings, Djorre