How can I create a report that displays text fields from multiple records in my table and embeds a related gauge charts for each record?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I am working with the relatively new gauge reports, and love the visual display these reports allow.  I am trying to create a report that embeds several gauge charts and some text data from one of my tables. 

I have a table of machines.  Each machine has a useful life which is based on # of widgets produced by the machine.  I need to show a gauge for each machine, with the gauge representing # of widgets for each machine. 

I would ultimately like to embed the respective gauge on each machine's form and in a "dashboard" type report.  I've tried iframes which don't work in forms and have minimal use in web pages because you can't restrict the size of the actual chart (only the size of the iframe) and image onload (which is challenging because I don't know much javascript...I seem to be running into the issue that charts are not image files). 

I'm willing to do a little "hard coding" and limit my dashboard report to only the top 10-12 machines because it seems dynamically created reports do not exist in quickbase.  Any help is greatly appreciated!


Photo of mzkorol

mzkorol

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Can you clarify your question?  Why not just make a dashboard page of a bunch of little gauge charts?  What is that it that you are trying to do that a dashboard page is not allowing you to do natively?
Photo of mzkorol

mzkorol

  • 0 Points
I have over 1000 machines.  I believe if I did what you suggest, I'd have to create 1000 gauge charts, correct?  I suppose I could use this approach as a short-term solution for the top 10-12 machines...I guess I was hoping for something more dynamic, and I also want to embed in the data form for each record.
OK, so you are asking if you can have a report of 1,000 records with 1,000 little gauge charts.I missed that the whole point was a report.  I have no ideas to do that and in fact since each Gauge chart is really a version of a summary report, that would mean to push a button and run 1,000 summary reports, so it would be very slow from a performance point of view even if you could get it working.  But I get what you mean, in practice, you might run the report with a filter for just the important machines.
Photo of mzkorol

mzkorol

  • 0 Points
My problem is that senior management wants a "gauge" because that is what they've seen from other vendors (who don't have half the functionality of what I've already built them, but that doesn't matter...this could be a Dilbert cartoon).  I need to do a better job of selling them on the red/yellow/green indicators for Actual # of widgets produced / Useful life # of widgets.  Thanks for the reply!
Well, an idea would be to find some graphics wiz to make  you 11 gauge-like icons from 0% to 100%.  Then have a formula to put up the  correct icon.  That's an easy formula.  You are not restricted to just the standard QuickBase icons.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
This is simple to do with script and the API. There are so few parameters that parameterize a gauge that you can easily generate 100s of gauges from QuickBase data and display them on forms, reports or on the dashboard. Here is a quick modification of a HighChart demo that shows two machine tools against their 100% useful life:

http://jsfiddle.net/2tghpnfb/2/embedded/result,js,html,css,resources/


QuickBase uses HighCharts for their charts but they have tightly bound their graphical chart building interface and chart parameters to the specific chart QuickBase supports. But HighCharts is a general purpose library that can generate just about any chart you want and it can be placed anywhere you want. All you have to do is (1) call the QuickBase API to grab the raw data for the chart, (2) process the raw data in some manner and convert it to the format HighChart requires, and (3) feed the results to the HighChart API specifying the data and options needed for some particular chart.

If you need help implementing this feel free to contact me using the information in my profile.
Photo of Sethu

Sethu

  • 0 Points
Hi, That's was useful. I need some help in implementing this. Is there a step by step guide?.