cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78 Regular Visitor
Regular Visitor

Stacked bar chart - able to sort by just one of the results?

I have a data set that shows if an employee passed or failed a test.  I would like to be able to show a stacked chart that shows how many times they failed and how many times they passed, which is easy enough, but I would like to be able to sort it by the fails.  

 

The default sorting options is only by employee or total number of tests.  Any way sort by fails?

1 REPLY 1
Community Support Team
Community Support Team

Re: Stacked bar chart - able to sort by just one of the results?

hi, @bryanc78 

You could try this way:

Don't drag "result type" field into Legend.

Then create two measure:

1. times of failed= Calculate( CountA( [employee] ),  "result type"="failed")

2. times of passed= Calculate( CountA( [employee] ),  "result type"="passed")

Then drag the two measure into Value and then sort by [times of failed]

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.