Multiple fields into a pie chart

To make a pie chart you would need to have individual records.  So let's make that happen.  Set up a special table to make this pie chart so it would just have a two fields, one for the for the values and the other for the labels.  It might be easiest to set up a parent record to hold these records as we will need to push a button to get the chart to update.

Create an Automation that will trigger off a date time field being updated. 
The first step will be to delete the records and then 25 steps to recreate the records.

To get the Automation to trigger you can have a date time field being updated and then use this technique to refresh the page slowly after the Automation has had a chance to run.

var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=[Record ID#]
& "&_fid_6=" & URLEncode(now());


"javascript:" &
"$.get('" &
$URL &
"',setTimeout(function(){" &
"location.reload(true);" &
"},10000));"
& "void(0);"; 

// 10000 = 10 second delay

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------