Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Column return column Header Title if a condition is met - ie cell has a 1 in it.

Hi there   I have a data set from a recent working from home survey that requested respondents to select their top 3 from some 5 options.   The survey data set looks like below and i'm keen to re...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    As amitchandak said, do unpivot columns on your '# option' fields to convert them to attribute and value. Then you can create a matrix visual with name on 'row', value on 'column', attribute on value field to achieve your requirement.


    Regards,
    Xiaoxin Sheng