Skip to main content
Question

Bar Chart Report - Dynamic Goal Line

  • July 20, 2023
  • 0 replies
  • 91 views

Is there a way to make the Goal Line for Bar Chart reports dynamic based on a summary value, instead of a fixed number?



------------------------------
Dan Park
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Quickbase Alumni
  • July 20, 2023

Not that I know of specifically with the 'goal line'. Gauges support a dynamic target but not bar charts unfortunately. If your intent is to show gap between the chart and the target - you might consider a stacked bar chart, where y-axis value 1 is your current value and y-axis value 2 is the 'remainder' to your summary target. 

So if you were tracking spend versus budget - you would summarize total spend as your primary y-axis then have another field for 'remaining spend' as just budget - spend and have that field be the second y-axis. This way the secondary color/data point displays how much you have left to spend in this example. You could go further as well in this format and have a third y-axis if you wanted to show 'overage' against the target, so you'd have a third value that shows how much over the budget you might be in a different color to visually see it when it crosses your dynamic threshold. 



------------------------------
Chayce Duncan
------------------------------