Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

100 % Stacked bar chart

Dear All,   I want to come up with a 100% stacked bar chart view as in the attached screenshot. Can anybody suggest what is the most efficient way of doing it?     Data structure provided...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Do you have any specific column that you use as ID? If yes I would split your model in two table one with all the Portfolio information that you will not unpivot and delete all the columns A to I and a second table that would be the ID column and the unpivot of the A to I columns then linked both tables by the ID column.

     

    To calculate the status you would use the 2nd table and for the rest of the setup the other table.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

On the query Editor select columns A to I and unpivoted then you will get two columns with attribute (A to J) and Value (status)

 

Now create a 100% stacked bar with the following layout:

  • Axis - Attribute column
  • Legend - Value Column
  • Value - Count of attribute.

Should give expected result.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks a lot MFelix  for this elegant solution.

I have follow up question to this solution. My database has couple of other columns, and when I unpivot these selected columns within the table a lot of extra rows are created. Also I wanted to filter based on the column in the sheet? How can I do that?