Forum Discussion
Matrix Visualization Multiple Columns & Rows of Data
You can search for a visual in the market place or try to create a table like this and display
union
(
summarize(table,"Name","Revenue","Amount",[Revenue Amount],"per ton",[Revenue Per Ton],"% of Revenue",[ % of Revenue])
,summarize(table,"Name","COGS","Amount",[COGS Amount],"per ton",[COGS Per Ton],"% of Revenue",[COGS % of Revenue])
,summarize(table,"Name","Processing Cost","Amount",[Processing Cost Amount],"per ton",[Processing Cost Per Ton],"% of Revenue",[Processing Cost % of Revenue])
,summarize(table,"Name","Gross Profit Margin","Amount",[Gross Profit Margin Amount],"per ton",[Gross Profit Margin Per Ton],"% of Revenue",[Gross Profit Margin % of Revenue])
)I will research this more to see if this provides what I need.
The suggestion of Union and Summerize is working well. I had to add an additional unique identifier in order to build a relationship with the other tables in the file. However, when I try to bring the data to the table it causes issues. In the matrix visual I brought over % of Revenue and Per Ton as an average and the Amount as a Sum. However, because not each identifier has a value it causes the % of Revenue to and per ton to not be exactly as expected. For example I would expect the % of Revenue to be 100%; it's not because there a few lines with no revenue thus there isn't a % of Revenue which causes the % of Revenue to be 99.63%.
Is there a way to resolve this issue either in the Matrix visual or in the table?
