cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wildchild Frequent Visitor
Frequent Visitor

How to graphic a Matrix

Im new in this, please help me to graphic this.

image.png

If you can not see the image i will explain.

In the first column I have listed for steel members...mark 1, mark 2, mark 3, etc...

The areas where those steel members will be sent are many, so I put in every columnn a facility name with its quantity. the columns are Area A, Area B, Area C...etc. The marks are not restricted to facilities, so they can be sent in different numbers to more than one facility. Also, in the final column I have the status of every mark...In review, Released,

 

How can i praphic it?

I want a stacked bar chart with facilities in Y axis, number of pieces by facility in X axis, and inside the color of the different status of theses pieces. Somenthing as it shows below (it is a random drawing so it may not match with the table).

image.png

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
moumipanja Regular Visitor
Regular Visitor

Re: How to graphic a Matrix

1. Go to Edit Queries, select columns Area A, Area B, Area C, Area D. Right click and select Unpivot Only Selected Columns. You will get a table like this from your original table.

1.JPG

 

2. Select Status and Attribute column. Right click and select Group By -> Advanced. Add new column name as SUM, select Operation as Sum and Column as Value. You will get a table like this. 

1.JPG

 

3. Select close and apply to exit from Edit Queries. Select Stacked Bar Chart, keep Attribute in Axis, Status in Legend and SUM in Value. 

 

1.JPG

View solution in original post

3 REPLIES 3
moumipanja Regular Visitor
Regular Visitor

Re: How to graphic a Matrix

1. Go to Edit Queries, select columns Area A, Area B, Area C, Area D. Right click and select Unpivot Only Selected Columns. You will get a table like this from your original table.

1.JPG

 

2. Select Status and Attribute column. Right click and select Group By -> Advanced. Add new column name as SUM, select Operation as Sum and Column as Value. You will get a table like this. 

1.JPG

 

3. Select close and apply to exit from Edit Queries. Select Stacked Bar Chart, keep Attribute in Axis, Status in Legend and SUM in Value. 

 

1.JPG

View solution in original post

wildchild Frequent Visitor
Frequent Visitor

Re: How to graphic a Matrix

Thank you! It worked perfectly.

moumipanja Regular Visitor
Regular Visitor

Re: How to graphic a Matrix

@wildchild I am glad that it helped. Could you please mark my post as a solution 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 263 members 2,805 guests
Please welcome our newest community members: