Discussions

 View Only
  • 1.  Percentages are not weighting correctly in the AVG summary in the table. It is just taking a blanket percentage average

    Posted 09-05-2018 14:30


    In the screenshot i'm referencing, I have a field that calculates a percentage which is labeled "Plan Success Percentage" which is the "Learners Completed" field divided by the "Learners Scheduled". When it is calculated within the record it works perfectly, however, in the "AVG" it is not accurate. In the screen shot you can see that "Learners Completed" is 427 and "Learners Scheduled" is 408 which 427/408 would be ~105%. The AVG of the percentages in the table is 115.9%. Is not weighting the records appropriately and just taking a blanket AVG of percentages without considering volume?


  • 2.  RE: Percentages are not weighting correctly in the AVG summary in the table. It is just taking a blanket percentage average

    Posted 09-05-2018 14:37
    Typically you will have a patent record and can summarize up the totals you need of the detail records. Then do the proper Avg math up on that parent record and make your report in the Parent Table as a Table report.


  • 3.  RE: Percentages are not weighting correctly in the AVG summary in the table. It is just taking a blanket percentage average

    Posted 09-11-2018 04:27
    Kyle - Mark's right.  QuickBase does not 'naturally' display weighted averages.  You need a parent table to do that work.  You can also try integrating Quick Base with an analytics tool like Power BI OR Tableau to do that analyses.  CloudBase Services has built many learning management systems and other apps that need weighted averages.


  • 4.  RE: Percentages are not weighting correctly in the AVG summary in the table. It is just taking a blanket percentage average

    Posted 10-14-2019 12:23
    Kyle,

    At Empower in Miami several new reporting tools were promised.  As we could not touch them yet, there is no guarantee that they will fix this issue but Quick Base is always growing.

    A different solution is to move your reporting out Quick Base and into a Business Intelligence/ Business Analytics package like Tableau, Power BI, Watson and many others.  Once you get your data out to a SQL DB you can do anything you want, any way that you want.

    We built a tool called Paasporter to Extract and create SQL DB for any purpose you can imagine.

    www.paasporter.com  

    Quick Base is king of business process problems.  SQL rules reporting.

    Don

    ------------------------------
    Don Larson
    ------------------------------