I have a query that is set up to pull data from the dates selected or by default the last month. The query gives back the percent of scrap per day, the average for the time selected along with standard deviations. I am trying to get the graph to be divided up in set 7 day increments (12AM Thursday - 11:59PM Wednesday) for the last 28-30 days. It would be nice to be able to get all of these on one graph. Any help/advice would be greatly appreciated. If there is anything I should be clearer about please just ask. Thanks.
It looks to me like that is just grouping the data to give one one record for the week as a total rather then showing each day. But I may be misinterpreting it (I am still new at this stuff). I can't figure out how to attach a picture or I would for an example of how I am trying to get this graph to look.
quote:Originally posted by visakh16
sounds like this to me ie aggregating data into timeslots
It looks to me like that is just grouping the data to give one one record for the week as a total rather then showing each day. But I may be misinterpreting it (I am still new at this stuff). I can't figure out how to attach a picture or I would for an example of how I am trying to get this graph to look.
quote:Originally posted by visakh16
sounds like this to me ie aggregating data into timeslots
[/quote] Nope...it gives you logic to group on any time slots (10mins,15 mins etc). One of parameters is timeslot over which you want to do the aggregation
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
[/quote]
Ah, okay. I have not been able to understand what it means. I will keep trying though. Thank you, and sorry for the late reply. I haven't been about to get into report builder since they are working on the server I'm using.
Report Builder - graph in sections by wk
Posted - 10/30/2012 : 09:25:25
