Column Chart with Average Line

  • 1
  • Question
  • Updated 1 year ago
  • In Progress
What is the best way to display a Line Chart with predefined values for different categories?

My chart is displaying tasks by type for a certain team. Using another model that takes the count of tasks and divides it by the countdistinct of created by I was able to get a rough estimate of the "average" for each category (first chart). Is there a way to create this line using pre-define minimums instead of a UI formula field? 

An example would be AE Connect = 20, Call = 250 etc. I've tried using the info found here: http://api.highcharts.com/highcharts/yAxis.plotLines but can't seem to get it working. 

Any help is appreciated. 
 
Photo of Josef Lagorio

Josef Lagorio

  • 2,874 Points 2k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Josef Lagorio

Josef Lagorio

  • 2,874 Points 2k badge 2x thumb
Any help is appreciated. 
Photo of Peter Hale

Peter Hale, Employee

  • 330 Points 250 badge 2x thumb
So, do you mean to have the line be the average of all of the tasks for that group?  You shouldn't need a formula field for that.  For using pre-defined variables, if those variables are stored somewhere in your data, you could use a formula field with a MODEL_LOOKUP function to get the pre-defined value for that particular category.