Confusion regarding utility of value labels
Hello,
Let's say I have a column of data with numerical values from 1 to 10, and I want to analyze a number of factors according to grouped values in this column. I've assigned the following value labels to the column:
'1 to 5'
'6 to 7'
'8 to 10'
Now I go to Graph Builder and set this column as 'Group X'. Instead of using my assigned value labels for grouping the data, Graph Builder uses:
1-2
3-4
5-6
7-8
9-10
Why isn't Graph Builder using my assigned groupings? How should I be approaching this?
Note: I should add that my first instinct was to create a new column using a formula to generate these groupings from the data in my original column; however, in attempting to do so, I learned that I can't use Conditional functions to create values that are a different data type than the original (in other words, numerical to character), so this appeared to be a dead end.
Regards,
Stefan
Added note regarding alternate strategy.
Message was edited by: sfkeydel
Message was edited by: sfkeydel
