Forum Discussion

SammySSammyS's avatar
SammySSammyS
Qrew Cadet
7 years ago

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

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!
Ask about Quickbase functionality
Formulas and functions
reports and charts
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    7 years ago
    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.
    • SammySSammyS's avatar
      SammySSammyS
      Qrew Cadet
      7 years ago
      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!