10 Replies Latest reply on Feb 10, 2014 9:53 AM by Matt Lutton

    Dimension with multiple data types?

    Susan Baier

      I have a dimension (RESPONSE) that contains two types of data -- numbers (1-7) and text (Always, Sometimes, Never).  How can I have this field present in my workbook both as a text and a data field, depending on the chart I want to show?  The numerical items are responses to ratings questions, and the text items are responses to multiple choice questions.  I have set up sets of the questions for each type, but if I set the dimension as a number I can't see any of the text responses (they show up as "NULL").  If I set the dimension as a string, I won't be able to do the numerical calculation on the ratings responses (AVG, etc.)