12 Replies Latest reply on Jan 30, 2017 12:59 PM by Naumaan Nayyar

    Drawing a stacked bar chart from complementary fields

    Naumaan Nayyar

      This is my first post here, and I apologize if my post does not meet standards. My problem is relatively straightforward, but if you'd like me to create a sample dataset, let me know!

       

      I have a dataset containing two numerical fields, X1 and X2, for categorical names, E. So my dataset looks like (E_1, X1_1, X2_1; E_2, X1_2, X2_2; ...). I'd like to create a stacked column chart where each column represents an entity E. All bars are to have the same height (100%) and each bar is proportionally colored in the ratio X1:X2. How can I achieve this?

       

      I've tried defining the two fields, X1 and X2, as measure values and played around with various "Percentage of" and "Compute using" options, but to no avail. I've also tried to  use the stacked bars graph option but it removes the named category and does not let me plot. I'd really appreciate pointers in the right direction. Thanks in advance!

       

      Sample dataset

      EX1X2
      E11020
      E21525
      E32013
      E4518
      E5911
      E6115
      E7187
      E82510
      E9144
      E101216