"Null" value in chart category is pulling a total...?

Questions
1

I have an aggregate model that takes the number of Events a sales rep creates and averages it - avg per week over a 4-week period.

Everything’s awesome…except for the part where there is now a category labeled “null”, which I’ve figured out is taking the average for the entire team (adding all Events and dividing by 4). In theory, this could maybe be nice for a manager, but A) no one’s going to know that when it’s labeled “null” and B) it’s skewing my graph so all the reps’ values look like ants next to an elephant.

This my field/formula:

This is my chart series:

And this is the result:

I’m still learning/playing with aggregate models and charting, so I’m hoping I just forgot something/missed a step.

2

Check your aggregate model, in the grouping section - look to make sure you are using “Simple” grouping method. If you use ROllup - it will add additional rows to your model that aggregate all values of your grouped records. Will mess up your chart for sure…