Hello! I have found that if you have more than 50% number values in a dimension that also contains text, whenever you try to add a table, all the text values are aggregated together (with any blanks) as "null", whilst only the numbers and their counts are displayed correctly. If you have less than 50% numbers, then all number and text values are displayed with their counts properly. This is causing me a problem as I want to show all the text values as well as the number values, and my data has more than 50% numbers. When imported, the data type is set to number by default, but changing this to text in Data Sources doesn't help.
Please, does anyone know how to override this? Thank you.
LinkedIn
Twitter
