Discussions

Expand all | Collapse all

Map Report

  • 1.  Map Report

    Posted 08-30-2021 12:58
    I would love to use a map report to see how many clients come from each zip code, but currently the map will only show the first 100 clients. Is there a workaround for this where I could have each pin represent 50 clients? Or even just have one pin per zip code and hovering over will show the number of clients? I would really love to be able to have a visual element for this data, and my current summary report is long and clunky. Thank you so much!

    ------------------------------
    Hunter Collins
    ------------------------------


  • 2.  RE: Map Report

    Posted 08-30-2021 13:43
    Edited by Mark Shnier (YQC) 08-30-2021 14:26

    I believe that the the  mapping tool from Juiced can do this.

    https://www.juicedtech.com/old-qb-maps

    Alternatively, a solution would be to create a summary report of all of your ZIP Codes and use that to populate a new table called ZIP Codes where the key field is the ZIP Code. Then you can make a native Quickbase map from the ZIP Code table rather than from your individual address table. 

    Had some kind of automation or pipeline to keep this maintained then you can have a relationship and summarize the number of customer locations so that you have a count for each  ZIP Code.


    But I do not believe that the native Maps report as much in the way of hover ability



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Map Report

    Posted 08-30-2021 14:58
    Hi Hunter,
    This is exactly the reason why we created Compass; here is a link to a quick 1 min video: https://quandarycg.com/peaksuite/peaksuite-compass/
    Compass can also be customizable; however, based on the above question, Compass can get you where you need to be without any additional customizations.
    Please let me know if you have any questions and/or would like to walk through a quick demo.
    Happy developing!
    Blair

    ------------------------------
    Blair Garrett
    Account Executive
    Quandary Consulting Group
    7703091224
    bgarrett@quandarycg.com
    ------------------------------



  • 4.  RE: Map Report

    Posted 08-30-2021 14:00
    Thank you!

    ------------------------------
    Hunter Collins
    ------------------------------