Chart Widget from table's totals
I am fairly new to quickbase and got the hang of it somewhat to make reports, dashboards, etc. I ran into a hiccup on a table that a peer would like to see data on.
The data has a total at the bottom for total "Invoice Amount" (each record is a job with a invoiced amount), then each record also has a "Total Hrs" where the total amount of hours that job took). Then a grand total of all the rows for Invoice Amount and Total Hrs. I wanted to make a simple calculation for a running rate where it divided the Invoice Amount / Total Hrs and put it in a widget on a dashboard.
I attempted adding a new field/column in the existing table and it takes the total from the given table all together and divide and spit that value into that field. However, this only did the calculation by row - not take the grand total of all the records/whole table itself.