Page break chart up by unit of measure

Question

Page break chart up by unit of measure

teej21012

SSC-Addicted

Points: 497
More actions
May 1, 2012 at 8:04 am

#273440

I have a bar chart with min, max, avg, and stddev values by a category being charted. The problem is that the categories are in different unit of measures, i.e. one of them is in milliliters (ml), one is in pounds (lbs), another is in torr (mmHg), on and on. The issue that then arises is there will be values in ml up to 1000 but you would RARELY see a value for lbs even close to that. This causes the graph to have highs and lows that are misleading. I haven't found a way to break the graph up into different unit of measures. Does anyone have an idea of how to go about this? Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 1

What are you using the chart for? Comparing the values would either need to normalise or create separate charts. Do you show changes over time?

Can you post the sample data and ddl, with expected results as this seems like a nice challenge to approach?

Fitz

teej21012 SSC-Addicted Points: 497 More actions · Answer 2

Ill try to explain it. I have this chart

.

It currently is broken up into the different unit of measure groups. What I want is to take those different measure groups and separate them into individual pages. As you can see, the y-axis has a range of 0-1000, which isn't really reasonable for the lbs unit of measure. Changes are not shown over time. They have start/end date parameters that they can select and the values returned in the chart reflect the data within that date range. I would like the expected results to look like this http://imgur.com/a/LMvzJ#0

I have attached a script to create the tables and load them with data. Uses tempdb. Thanks

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 3

teej21012 (5/2/2012)
Ill try to explain it. I have this chart
.
It currently is broken up into the different unit of measure groups. What I want is to take those different measure groups and separate them into individual pages. As you can see, the y-axis has a range of 0-1000, which isn't really reasonable for the lbs unit of measure. Changes are not shown over time. They have start/end date parameters that they can select and the values returned in the chart reflect the data within that date range. I would like the expected results to look like this http://imgur.com/a/LMvzJ#0
I have attached a script to create the tables and load them with data. Uses tempdb. Thanks

Steps:

1) Create a matrix within the report.

2) Remove the first column (normally row headers as we do not need this)

3) Add the UOM (measure type) to the header of the remaining column. This will divide the measures by measure type so that only the LB measures appear etc.

4) Add a chart to the details row as you had before, with 4 measures in the values and only the study question in the category groups.

5) Run the report.

Fitz

teej21012 SSC-Addicted Points: 497 More actions · Answer 4

Simply amazing. Thank you very much. There's no upvote button but if there was, it would have been pushed 1024 times. :hehe: