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

  • 1
  • Question
  • Updated 3 years ago
  • Answered
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.
Photo of Monica Lorey

Monica Lorey

  • 384 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,678 Points 20k badge 2x thumb
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....