I am a novice CR user running into a charting problem. I have a report that captures completed training for a user that is grouped by manager, then region. For each user I count the number of completed courses using: distinctcount({Course.Title}, User.Last_Name}).  

 

Next, I created a similar count for total course completions by manager, and I used a formula to determine the average number of courses completed for each manager by dividing the total number of courses by the number of employees: {#CourseCount } / {#EmpCount }

 

My challenge is that I need a chart to display this formula for each manager, but the formula is not selectable in the Chart Export (advanced).  I realize that formulas can’t be easily used in charts, but this must be a common need.  

 

Any advice on how I can accomplish this is greatly appreciated.