Discussions

 View Only
  • 1.  Gauge Charts for COUNT (not sum or avg) for KPI widgets

    Posted 03-13-2023 10:05

    I guess I need Gauge Chart / Dashboard KPI 101 course....   I mostly use gauge charts to COUNT occurrences of something so that I can then display the occurrences as a KPI on a dashboard.   By nature gauge charts are intended to sum or average data.   I have been successful thus far in 'summing' some not numeric field so have been clubbing along well enough after I learned early on that summing a numeric Record ID can result in a very large number.  LOL

    In any case, I thought I would ask about the proper way to count records for the purpose of displaying as a KPI on a dashboard.



    ------------------------------
    Annetta Coleman
    ------------------------------


  • 2.  RE: Gauge Charts for COUNT (not sum or avg) for KPI widgets

    Posted 03-13-2023 11:01

    I think you are just missing seeing that the very last choice on that drop down list of numeric fields is the one to simply count the # of records.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Gauge Charts for COUNT (not sum or avg) for KPI widgets

    Posted 03-13-2023 11:11

    Guess it was Gauge Reports 101.   LOL.   Thanks for taking the time.   :)



    ------------------------------
    Annetta Coleman
    ------------------------------