Forum Discussion

Incipient's avatar
Incipient
Icon for Helper I rankHelper I
4 years ago

Matrix Visual - Single 'Values' field over multiple columns with different decimal places

I am using a Matrix visual with unpivoted data (attribute-value pairs). I have the 'attribute' in the "Columns" field, and the "value" in the values field'   Quick example (with made up data!) has ...
Need Help
Incipient's avatar
Incipient
Icon for Helper I rankHelper I
4 years ago

amitchandak Thanks for the suggestion!

 

Yeah a measure is my fallback, but it's very far from remotely good.

 

My data is a lot more complex than this, so the measure is not so straightfoward, and a functional issue is when users export data that has been converted to text with format(), the xlsx has all of the cells as 'text' not a number, so it heavily breaks usability in excel.