Discussions

 View Only
  • 1.  How to do year-to date calculation and show on a chart

    Posted 10-20-2022 16:22
    Hi Everyone,

    I'm trying to create the below chart in QuickBase. I selected line & bar chart type so that count of  "Approved" proposals per month can be shown on bar and area (Approved YTD field with light green in the below chart) can be shown in the form of line chart. As I don't see bar-area chart type option in QB


    I'm not sure how to calculate count of approved YTD (year to date value with light green in the above chart) values here?

    Furthermore, can I replace bar by stacked bar chart?  There are 2 subcategories within "Approved" field so if possible would like to show that as well. I'm not sure if there is a way to combine different types of charts in 1 chart or we can select chart only from this list.



    Thank you in advance! 


    ------------------------------
    Mrunali Kadam
    ------------------------------


  • 2.  RE: How to do year-to date calculation and show on a chart

    Posted 10-20-2022 19:37
    I suggest that you use a waterfall chart type if you want a stupid simple solution.  It will give you the basic results that you want, although in a different presentation format.

    But if you want to more closely replicate our chart image example, you will ned to get up to speed on Formula Queries to get that rolling sum YTD totals field.
    @Sharon Faust a.k.a. The Quickbase Junkie has some wonderful training material including this video.

    https://www.quickbasejunkie.com/blog/how-to-running-total

    .






    ​​​

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



  • 3.  RE: How to do year-to date calculation and show on a chart

    Posted 10-20-2022 19:45
    Great! Thank you for sharing the training material link, I'll take a look.

    ------------------------------
    Mrunali Kadam
    ------------------------------



  • 4.  RE: How to do year-to date calculation and show on a chart

    Posted 10-21-2022 16:09
    @Mrunali Kadam

    As Mark mentioned I have a number of resources on Formula Queries that will assist with this chart.

    Get the Query Formula Playbook here: https://www.quickbasejunkie.com/query

    This video in particular covers charts like the one you are looking to build.



    ------------------------------
    Quick Base Junkie
    Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------



  • 5.  RE: How to do year-to date calculation and show on a chart

    Posted 10-25-2022 14:46
    Thank you very much for creating and sharing the links. I went through the training material and it is very helpful.

    Thanks again!

    ------------------------------
    Mrunali Kadam
    ------------------------------