I am attempting to display a bar graph (by employee name) that is based off a "Score" calculation which is basically a point system if certain metrics are met. (Example: Metric1 above goal, +2 points. Metric2 within 95% of goal, +1 point, Metric3 below 95% of goal, 0 points)
The graph that I am trying to display has employee names on the rows, and "Total Score" on the columns. The issue is when I am trying to do a rolling 6 month average with each of the metrics, it makes me bring in the Date(Year) and Date(Month) into the detail screen, which then creates individual "sections" for each month, instead of 1 score per employee, it displays 6 scores (one per month) added together.
Anyone have any ideas?
I think what will be required is a calculated field to determine if the data is part of the rolling 6 months if so then score.
We can then use this field as a sum.
If you can share a sample workbook I can assist you with this