Chart Widget from table's totals

Question

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.

donlarson · Answer

Getting the totals from table report into a formula is not available.

You can build a separate summary report that will give you total Invoice Amount and Total Hours and then have it calculate your total Running Job Rate.

markshnier__you · Answer

Just to add to Don's post above,&nbsp; in the Summary Report Type, you have an opportunity to createStep 1: Define summary variables&nbsp;where you can sum up your total invoice amount and total hoursStep 2: Write summary formulas&nbsp;where you can divide one by the other to get your "Rate".Then you will at that Rate column to your report in the summarize what section.&nbsp;Can you find that you need to save the report settings and then re-open it in edit mode to iterate through those steps easily

Forum Discussion

Chart Widget from table's totals

Step 1: Define summary variables

Step 2: Write summary formulas