Forum Discussion
Matrix table couldn't display values
Hello Bobby21,
The Matrix visual is used to show a measure aggregated over some grouping. The grouping can happen in 2 dimensions, Rows and Columns.
Since you measure is a Text, the options for aggregation function are First, Last and Count.
To fix your issue and show exactly as you have on the the spread sheet you have, you need to add another level of grouping that would be unique per row. Something like an Order number.
Then add the Order # to the Row hierarchy.
Ramy
Anonymous
You can fill down the null countries in Query Editor as RamySaroufim said. And then use the Table visual to show the result as below.
Best Regards,
Herbert
Hello Bobby21,
The Matrix visual is used to show a measure aggregated over some grouping. The grouping can happen in 2 dimensions, Rows and Columns.
Since you measure is a Text, the options for aggregation function are First, Last and Count.
To fix your issue and show exactly as you have on the the spread sheet you have, you need to add another level of grouping that would be unique per row. Something like an Order number.
Then add the Order # to the Row hierarchy.
Ramy
I added 2 other groupings (state and total value of order). This gave out my desired layout.