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 |
|
Cody
Starting Member
24 Posts |
 Posted - 2009-02-11 : 21:19:34
|
| I can't think my way out of this one, maybe someone can help.I have input data like this:grouping, value_1, value_2, value_3I put it in a table that groups on the grouping column. In the table is a column chart. The column chart has 3 values set, as the sum of each of those value fields. ie: value 1 is sum(value_1), value 2 is sum(value_2), etc.This looks fine, and it gives me a 3 column chart that is accurate.When I change the chart to a line type though (because I want a spark line showing the movement in that value), everything goes to hell. It looks blank, but if I create a very large version, it appears to draw the three values like this:---------ie: 3 parallel lines across the chart. That's not what I want. I want a line whose value varies in 3 places.But I'm not sure how to achieve that when all 3 figures are in the same group of input rows.Help? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-12 : 11:16:13
|
if you want single line with three points, your dataset query should be likeselect grouping, sum(value_1) as plotvaluefrom tableunion allselect grouping, sum(value_2)from tableunion allselect grouping,sum(value_3)from table |
 |
|
|
|
|
|
|
|
My brain is dead, help get a line chart to work