Forum Discussion
Question on Conditional Column as Parameter
I am working on a skillset survey, and the rating is know of, beginner, intermediate, advanced and expert, and I have used a conditional column to assign values 1, 2, 3, 4, and 5. I would like to keep my text in my visual presentation of the data, so I would like to avoid using replace value.
It is quite an extensive survey, so I would like my definition set in my conditional column to include all coloumns, but I am stuck on this. Do I need to set up a parametre instead? If so, I would be very grateful for any help 🙂
Thank you so much!
9 Replies
Hi Anonymous ,
“so I would like my definition set in my conditional column to include all coloumns,”
I don't particularly understand your needs, could you show me a sample data model and describe your needs in detail.
Best Regards,
Lionel ChenThank you for your replies 🙂
This is my data as I have been sorting it in Excel. I am working on creating graph example and it is important that rating is not changed to a numerical value. So I have created a conditional column to assign numerical value to the text, but my question whether I would need to create a conditional column for each column in my spreadsheet, or is there someway smarter to do it?
hi Anonymous
I didn't get what you really need.
Do you want to show 1 as beginner, 2 as intermediate and so on?
Anonymous,
Thanks for the screenshots. Now I understand you better.
But please provide a sample data that can be copied. Thanks
