Discussions

Expand all | Collapse all

Page to display charts and image for visual reference

  • 1.  Page to display charts and image for visual reference

    Posted 07-12-2019 16:51
    I worked out a way to compile icons generated by formula fields into a rich visual including an image and the result looks like this:
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1797177/RackMultipart20190712-22505-12rpo4d-image_inline.png?1562949224">

    This does exactly what I needed; it shows a visual for a single record.

    Now what I would like to accomplish is to show a similar visualization but rather than show the icons pertaining to an individual record, I would like to show pie charts that I have created for each of the joints in order to show the overall scoring of all records. It should look something like this:
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1797178/RackMultipart20190712-63456-19lgezc-image_inline.png?1562949996">

    This would be a great resource for our employees to be able to take initiative and help generate ideas to reduce ergonomic risk on jobs.

    I imagine this being best tackled in a Page, but do not know how to go about starting. I have all of the pie charts created; the images in the above compilation are of the actual pie charts.

    Any feedback would be greatly appreciated.


  • 2.  RE: Page to display charts and image for visual reference

    Posted 07-12-2019 17:31

    I am very much impressed and would like to display a similar approach.  I work in the safety industry and think this visual would be perfect to help bring awareness to our 2000 field employees.  How to go about making what you have; I don't know, but would be grateful if you could direct me in the right way.  Feel free to email me directly.  Great work.  I will be watching this thread.








  • 3.  RE: Page to display charts and image for visual reference

    Posted 07-12-2019 17:34
    Hi Jeff. Thanks for the compliment. Here is the link to the original post:
    https://community.quickbase.com/quickbase/topics/combine-fields-using-formula-rich-text">https://community.quickbase.com/quickbase/topics/combine-fields-using-formula-rich-text">https://community.quickbase.com/quickbase/topics/combine-fields-using-formula-rich-text

    I would be glad to answer any questions you may have about setting up the formula rich text field to display the individual record visualization there.


  • 4.  RE: Page to display charts and image for visual reference

    Posted 07-15-2019 13:19
    Adam,  Did you ever get the pie chart concept to work?


  • 5.  RE: Page to display charts and image for visual reference

    Posted 07-15-2019 13:41
    Not yet. I hope to spend some time on it this week.


  • 6.  RE: Page to display charts and image for visual reference

    Posted 09-25-2019 15:40
    Complete solution in this thread:
    Pie Charts

    ------------------------------
    Adam Keever
    ------------------------------



  • 7.  RE: Page to display charts and image for visual reference

    Posted 09-25-2019 17:30
    You can save time and improvement any charts using script. With the help of Dan's posts, I am now able to destroy charts and rebuild them with any of the Highcharts API options. 

    I use IOL on 10 dashboard pages, each has 3 pie graphs and then use those dashboards in iframes on a custom HTML page. It loads 32 pie charts on this one report and modifies them all on page load. 
    -removes legend
    -move labels inside pie
    -static colors set for each status, normally charts revert back to their default colors when new records are added each month. Now I just keep the chart on the default colors and let my script change them for me!


    Short example - hide legend
    var chart = Highcharts.charts[0];
    var options = chart.options;
    chart.destroy();
    options.legend.enabled = false;
    var chart = new Highcharts.Chart(options);​


    ------------------------------
    Everett Patterson
    ------------------------------