Discussions

Expand all | Collapse all

Adding a National Average to A Chart

  • 1.  Adding a National Average to A Chart

    Silver
    Contributor
    Posted 07-26-2017 12:23
    I have a simple bar chart which basically reports on the budget for each state. Works OK.  But there is a need for us to show national position in the same chart so that one bar is National and rest are state bars.  Seems like I have to create a another 'state' known as national but not too sure how to add this to chart alongside the states.  Will appreciate some help.  


  • 2.  RE: Adding a National Average to A Chart

    Silver
    Contributor
    Posted 07-28-2017 12:39
    Could someone assist with this? 


  • 3.  RE: Adding a National Average to A Chart

    Silver
    Contributor
    Posted 08-03-2017 05:50
    Surprisingly did not get any response. Hopefully I can. 


  • 4.  RE: Adding a National Average to A Chart

    Posted 08-03-2017 12:18
    It might help if you posted a screen shot of the configuration of your Chart report so we can see the type of bar chart you are using and that your settings are.


  • 5.  RE: Adding a National Average to A Chart

    Silver
    Contributor
    Posted 08-03-2017 21:28
    e
    Thanks the attached hand drawn chart was sent to me by a user if this gives you an idea.  I can simplify it to the point that we report on one FY at a time instead of lumping two FY. I did the chart without the national position which is easy enough but adding a 'national' state, I was not too sure about that.  


  • 6.  RE: Adding a National Average to A Chart

    Posted 08-03-2017 23:38
    I think that the only chart type which can do this, if it's possible in native QuickBase at all is the Chart type Line and bar, because that chart type can chart two sets of data on the same chart.  But I also know that the scaling for the two lines is not the same on the left and right vertical axis, so that report is probably not gong to satisfy the users.

    There is an add on service i have used a but called easy insights. http://www.easy-insight.com/

    It has much more capability that native Quick Base charts and also it has a native live QuickBase Interface.  ie when you run the chart in easy insight it pulls the data live, from QuickBase.


  • 7.  RE: Adding a National Average to A Chart

    Silver
    Contributor
    Posted 08-04-2017 01:12
    Many thanks for your help.