I am building a new cube based entirely on uploaded Excel Spreadsheets. When I try to do the mapping I run into an issue with creating any measures that are NOT numeric (so, string or text).
Error message: Only integer and decimal columns can be used as measures for “XXXXX”
Here’s a rough idea of the type of data:
Points Received can be mapped as a Measure, no issue. NONE of the others can. You can have them as Dimensions. That’s it. We use EazyBI for Jira, and we have lots of text-only measures, so I know it can be done. What am I missing when it comes to this type of upload?
A measure indeed is a quantitative numeric value that can be summed up, calculated averages, etc. There is no meaningful way to sum up or calculate the averages of names and other text values.
When mapping your data, you indeed can map the string/text values as dimensions. Additionally, you can append the “Row count” measure. This can be used in your reports as a counter for how many times the Name/Team appears in your data.