I have a variable in my data called "Bus. Unit". There are 3 values business units - 10, 50 and 22. The variable is part of a larger spreadsheet that loads via data load editor.
I use this field as a selection filter in one of my Sense sheets, but would like to change the business unit values to more meaningful descriptor in the actual filter display, such as:
10 = 'apples'
50 = 'oranges'
20 = 'grapefruit'
How do I accomplish this? Do I add a command into the data load editor, or someplace else? What function do I use?
