Forum Discussion
Helper IComplex scoring from form questions
Helper IThe issue I'm having is if you look at the raw data, all the data should be grouped by the respondent ID and I should be able to drill down of the area of the business and then by portfolio (its a branching in forms) but for some reason, when using a group by or duplicating the data it doesn't allow for a drill down other than simply putting a filter on to include functions. I'm wanting to do a full maturity on all areas of the business and create a scoring based from the scoring table, but when each skill is inputting it does not allow them to be added up using the custom table variables. Any solutions on how to get the data to be grouped and the measure to calculate each answer when there could be multiple selected on a field?
Super Useryou'll need to do some input data scrubbing before this may be useful.- knowledgesearch
I've scrubbed the data and unpivotted all other columns that I've needed to be drilled down, and the scorecard all the data has been cleansed and matching up. However, with the custom variables measure I've created, it's still finding it difficult to add up items that are on the same field as a multiple choice. Any ideas on how to add multiple choices to the scoring card other than splitting the columns up, as it should be an area all on it's own or is it not possible.
- lbendlin
you could create ever more elaborate parsing rules. This means permanent maintenance as your users will continue to find ingenious ways to break your existing rules.
Or you could consider using a different tool - one that is better suited to handle your unstructured data.