-
1. Re: Shapes for Multiple Measures
Tom WOct 18, 2017 11:21 AM (in response to Jordan Laughlin)
I apologize for not attaching the workbook and data, but it is connected to SQL tables and has a lot of sensitive data.
You can always still attach a sample - Packaged workbooks: when, why, how
I'd suggest you change the mark type to 'Shape' and then drag measure names onto the marks card.
-
2. Re: Shapes for Multiple Measures
Jordan Laughlin Oct 18, 2017 3:34 PM (in response to Tom W)Thanks, Tom. I attached a sample workbook with a sampling of the data to the original post.
I'd suggest you change the mark type to 'Shape' and then drag measure names onto the marks card.
I tried your suggestion, but this only adds a different shape per measure (e.g. a star for the 'furnished check' measure), rather than a shape per measure value (X for 0, check for 1, blank for null).
-
3. Re: Shapes for Multiple Measures
Tom WOct 19, 2017 8:34 AM (in response to Jordan Laughlin)
Sorry, I misunderstood. You are correct, you cannot drive the shape off the measure value.
One alternative is to setup a bunch of fake columns (1 per 'check') and then setup the shape for the individual column, one per check.
This is achieved by created a calculated field called 1 with a formula of 1. If you drag it out onto the column shelf and set the aggregation to 1, it will always be 1. This allows you to set the axis range to be a min of 1 and max of 1, then your mark (in our case a shape) will be centered in the middle of the column.
I've set you up an example with three fields. You'll need to create some new calculations to determine if the check is an error or not, you'll see in my examples how I've done this.
-
Future MLS_DRAFT_Sample (1).twbx 85.2 KB
-