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.
| Author |
Topic |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-10-23 : 08:37:17
|
Hi, I have a report with charts attached. The chart values show combined values for a value but in the matrix I have displayed the values by grouping. I would like the chart to also show different group values not the average or combined value. Example |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 10:07:19
|
| currently what all are you providing as values to chart to plot? |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-23 : 10:51:27
|
| Currently I have a single line for each day of the week representing an average Occupation value for different types (G,C,S,O). What I want is to be able to have 4 lines for each day showing each subgroup rather than the average of them. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-23 : 11:06:46
|
| The value I provide to Y axis on chart is =Fields!PercentOccupancy.Valuewhich is coming from stored procedure where there is a GROUP By on the types(G,C,S,O). So if I run proc in SSMS I a get a new row for each type but in the chart it is averaging these. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 11:24:22
|
| Does that mean your SP is returning average values? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-23 : 11:54:42
|
| No SP is returning a seperate row but I can not get chart to display these distinct values Chart is displaying a single line for each day (first Grouping in Matrix) I thought this single line was an average but onlooking closer it is value from first row.I can get an average line using AVG() around the Fields value. But I want chart to show seperate lines for each subgroup not an average or the first value. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 12:47:48
|
| ok then include the subgroup field in series group |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-24 : 04:24:00
|
| Thanks for your help that worked fine. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-24 : 06:55:35
|
quote:
Originally posted by darkdusky
Thanks for your help that worked fine.
Cheers  |
|
|
|
|
|
|
[Solved] Split chart data into groups