How to do year-to date calculation and show on a chart

Question

Hi Everyone,I'm trying to create the below chart in QuickBase. I selected line &amp; bar chart type so that count of&nbsp; "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 QBI'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?&nbsp; 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!&nbsp;------------------------------Mrunali Kadam------------------------------

markshnier__you · Answer

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
------------------------------

mrunalikadam · Answer

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------------------------------

mrunalikadam · Answer

Great! Thank you for sharing the training material link, I'll take a look.------------------------------Mrunali Kadam------------------------------

quickbasejunkie · Answer

@Mrunali KadamAs 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/queryThis video in particular covers charts like the one you are looking to build.

​------------------------------Quick Base JunkieQuick Base Junkiehttps://quickbasejunkie.com------------------------------

Forum Discussion

How to do year-to date calculation and show on a chart