Report Builder - graph in sections by wk

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Report Builder - graph in sections by wk

Author

Topic

amanalyn
Starting Member

9 Posts

Posted - 2012-10-30 : 09:25:25

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.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-30 : 09:57:18

sounds like this to me ie aggregating data into timeslots

http://visakhm.blogspot.com/2010/02/aggregating-data-over-time-slots.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

amanalyn
Starting Member

9 Posts

Posted - 2012-10-30 : 11:20:25

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

http://visakhm.blogspot.com/2010/02/aggregating-data-over-time-slots.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-30 : 11:27:13

quote:
Originally posted by amanalyn

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

http://visakhm.blogspot.com/2010/02/aggregating-data-over-time-slots.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

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/

amanalyn
Starting Member

9 Posts

Posted - 2012-11-02 : 08:07:34

[/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.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-11-03 : 22:43:13

ok cool
let me know if you need any more help

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources