Forum Discussion
Sort Order not working - There can't be more than one value when there is only one value!
I have a lot of evaluation data (table name is [*All Years - Evaluation Data]) and one of the questions/columns in my dataset is a Customer Satisfaction score (column name [I was satisfied with the q...
1. Did you double check for any leading spaces or case sensivity mismatches between your maintable and sort order table? - Yes! I went to the raw data and copied the categories exactly how they appear in the data, so I ruled that out as an issue
2. Do you have nulls or blanks in this column [I was satisfied with the quality of this session]? - I did, but I replaced those with "NULL" and have "NULL" as a category in my sort order reference table
I have tried everything and it is not working... ugh so frustrating!