Okay this is my first posted question, so hopefully I can give the right amount of background information.
The basic question is:
Can a single row of data be included in more than one mark?
If so, how?
The data file represents rating of a work product. One row represents the rating of a single instance of the product.
The product is first rated by two 'Novices' (Rater 1 and Rater 2)
The order of rating is forcibly preserved in the column headings.
The product is then rated an 'Expert' who provides two scores. These are averaged to form a baseline against which accuracy is measured
Measure the accuracy of the novice raters against the expert baseline, and provide the information in a bar graph
All rater's accuracy must be displayed simultaneously
The accuracy calculation for a given novice should include all the data whether they participated as the first or second rater
Basically I want row 2 to contribute to the mark representing both Rater C and Rater H, but conditionally use the correct score column in the accuracy calculation.
Attached is a workbook where I took an approach using a parameter and several calculated fields to perform the heavy lifting.
The trouble is that the workbook culminates in a dashboard that selects a single rater and displays detailed information on the dashboard. The dashboard works great for individuals, but it doesn't provide any good summary capabilities.
I've provided two demo worksheets which point in the direction of where I'm trying to get
Group Accuracy (parameter)
Group Accuracy (no parameter)
Each has it's own problems which are described in the captions
I would prefer not to reshape my data before bringing it in for a few different reasons, so I'm looking for a solution which does not require this.
Using Custom SQL to alter the shape of the data as it is pulled into Tableau from the excel file might be an option, however.
Combining Raters 1 and 2.twbx.zip 155.6 KB