Hey all!
I'm having some trouble with my graph.
This is what I have so far (attached pic 1).
I want to add the head count total under each percentage as a reference. It is easily done by taking sum of the measure instead of average (attached pic 2).
I have provided an example of what I want to happen (attached pic 3).
A little bit about the underlying data:
The primary key of the data is an employee ID. Each of the "completed" is a class that is marked 1 if an employee has taken the class and 0 if the employee hasn't.
People are grouped using a calculated field based on the number of contributions to a system.
Avg. Completed A Is the percentage of people who completed the class.
Sum Completed A is the total number of people who completed the class.
Thank you so much!
PS. Unfortunately the data is confidential, so I can't package and attach a worksheet...
Without knowing your calculation, I am not sure if this is what you're looking for, and due to spam restrictions, I can't add a workbook to the thread, but here's a screen shot using the Superstore sample data:
What you do, is drag each of the values that you want to display to "Label" in the marks card, and it will stack them within the same box.
