Skip to main content
Question

What Chart Enhancements Do You Need?

  • October 11, 2016
  • 0 replies
  • 66 views

What Chart Enhancements Do You Need?

I have a new technique called "Un-HighCharted Waters" which will take a QuickBase Chart and enhance it in some way using simple script. For example, the needed enhancement may be adding an additional legend, annotation, series, etc to an existing chart - something that can't be done with native features. If you have such a need feel free to reply with a short description and I will try and work a few of the responses into a demo. Thanks in advance.


This topic has been closed for replies.

Forum|alt.badge.img+5
  • Quickbase Alumni
  • October 11, 2016
Would be nice to be able to set the scale on the axes for line and/or bar charts. 

  • Author
  • Quickbase Alumni
  • October 11, 2016
Easy to do - I will incorporate this into my examples.

Forum|alt.badge.img+5
  • Quickbase Alumni
  • October 11, 2016
something else that would be useful is the ability to set the 'goal' on a gauge type chart to a field value as opposed to a discrete value.

  • Author
  • Quickbase Alumni
  • October 12, 2016
Also easy to do.

  • Author
  • Quickbase Alumni
  • October 13, 2016
This demo needs a little more work to make it easier to use and integrate but the guts of it are working properly. Since QuickBase in not providing a lot of help in using JavaScript with the product you sort of have to get creative in how to do it yourself. For this example I created a Tasks table with a task/button for opening a new window with the chart report and adding the script into that new window to redraw the chart with the modified properties (in this case a different maximum yaxis value). Other chart modifications and integration options are possible.

Tasks Table ~ Click "ModifyChart.js" Button and note the scale change on redraw
https://haversineconsulting.quickbase.com/db/bk89redf6?a=q&qid=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=523

You can modify any feature of a QuickBase generated chart but some more work probably is needed to make it easier to use. More to come as I have time. Feedback would be appreciated. 

UPDATE: I forgot to mention that this is my database for UFO Sightings in the United States. You really need to check out how your state ranks in sightings. Yeah it is a real thing - read today's news..

https://www.youtube.com/watch?v=2MRdtXWcgIw

Forum|alt.badge.img+5
  • Quickbase Alumni
  • October 14, 2016
great song, great band . . . even with Tom out chasing aliens.

Hi, I did what is supposed I should be doing but I am no able to make it works. 

This is the "paste" I used, 

(function(){

  var querystring=document.location.search;

    var urlChart = URLRoot() &"db/bniy76a59?a=q&qid=11";
   
   
    $(win.document).ready(function() {
     console.log("hi");
    setTimeout(function() {
        var injectedScript = "<script>";
        injectedScript += "var chart = Highcharts.Chart[0];";
        injectedScript += "var options = chart.options;";
        injectedScript += "chart.destroy();";
        injectedScript += "options.yAxis[0].min = 0;";
        injectedScript += "options.yAxis[0].max = 80;";
        injectedScript += "new Highcharts.Chart(options);";
        injectedScript += "</script>";
        win.$(win.document.body).append(injectedScript);
      }, 2000);
    });
})();

If any one was able to made it work I would be thankful to get the script he used 

Thanks.

  • Quickbase Alumni
  • September 20, 2018
Is it possible to show trend lines on charts with this technique?