Forum Discussion

DanPark's avatar
DanPark
Qrew Member
10 months ago

Bar Chart Report - Dynamic Goal Line

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 ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

If you use a Line chart type instead of a bar chart then you can have multiple lines.  Then you might be able to contrive to have line which is horizontal as a goal line,



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
10 months ago

Similar to Mark's suggestion you could do a 'line and bar' chart, combine the best of both worlds where the line chart is your target, bar is the summary.



------------------------------
Chayce Duncan
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    10 months ago

    I think that the problem with the Line and bar chart is that the scale is different for the lines and the bars..... one is on the right and the other is on the left and they will be scaled differently..



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------