SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report Builder - graph in sections by wk
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amanalyn
Starting Member

USA
9 Posts

Posted - 10/30/2012 :  09:25:25  Show Profile  Reply with Quote
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

India
52323 Posts

Posted - 10/30/2012 :  09:57:18  Show Profile  Reply with Quote
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/

Go to Top of Page

amanalyn
Starting Member

USA
9 Posts

Posted - 10/30/2012 :  11:20:25  Show Profile  Reply with Quote
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/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 10/30/2012 :  11:27:13  Show Profile  Reply with Quote
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/

Go to Top of Page

amanalyn
Starting Member

USA
9 Posts

Posted - 11/02/2012 :  08:07:34  Show Profile  Reply with Quote
[/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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 11/03/2012 :  22:43:13  Show Profile  Reply with Quote
ok cool
let me know if you need any more help

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000