How can I add a target goal for each individual column in a chart?

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Hi,

I have a bar chart built which shows the amount of tests completed (Y-axis) in each month+year (X-axis).  Each individual month requires a different amount of tests to be completed.  I am looking to display the amount of tests that need to be completed for each individual month+year.  Essentially, this will be used to verify every test has been run for each month+year.  For example, if the amount of tests completed for June is 17 but there are 18 required, I would like for the graph to display this.

I know that you can set a goal line for a graph, however this is a goal line for all values and not just for one specific column which is what I am looking for.  Is there some other way for me to display the amount of tests that need to be completed for each individual month+year?  I've thought about adding a second column for each month+year to display the amount of tests needed to be completed through a calculated column however I've had some trouble with this as well.

Any ideas would be helpful.  Thank you!
Photo of SammyS

SammyS

  • 256 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,176 Points 1k badge 2x thumb
If you can get to the # of tests completed and # of tests remaining (the # required minus the # completed), in two different fields, you can show them both in a stacked bar chart. You could show the # completed in green, and the # remaining in red, or something along those lines. This way, it would be clear what the total is (the total height of the combined bars), and how close you are to reaching it.

I suppose you could also indicate an overage with a third field/stacked bar/color.

Hope this helps.
Photo of SammyS

SammyS

  • 256 Points 250 badge 2x thumb
Actually a great idea.  I'll have to play around a bit to get the number of tests per month+year into a field, but if I can get that done the stacked bar chart will definitely be a good idea.  I appreciate your help!