Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Progress bar calculation and design

The table format is as shown above. I have a measure for % calculation which is sum of 1s divided by the total number of rows. Each Category is supposed to have a different % as shown. I want t...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Anonymous I see the issue, your data is in pivoted shape, and you need to unpivot it.

     

    Transform Data -> Select Id Column -> Right click -> Unpivot other columns, it will create two columns attribute and value, rename those as you fit and then use attribute columns (or whatever you rename it to) on the y-axis.

     

    HTH

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

Anonymous if that is what you want trick is to add another measure let's call it % 100 and change the format of this measure to %

 

% 100 = 1

 

create a cluster bar chart, add category on y-axis and % count and % 100 measure on the x-axis, and the change the layout settings to overlap as shown below/

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Parry2K, 

    Thank you for your prompt response. This is working great only for 1 of my 4 categories. I am confused about the Attribute field that you have on the Y-axis. I don't have a parent field for each of my 4 category columns. Cat1, Cat2, Cat3 and Cat4 are distinct and mutually exclusive categories and they appear as columns in the underlying dataset. Your blue/blue bar chart looks great though. That is what I am looking for. Can you explain the Attribute column and how to get Cat1, Cat2, Cat3 and Cat4 to appear on Y-axis all at the same time as seen in your chart?