Hi everyone,
I reached out to Quick Base support but unfortunately got the most ridiculous no effort answer ever :(. So disappointed in that honestly as they are normally helpful. I assume checked...
You should sort the chart on the invoice date field grouping by month. Then the months will be in the correct sequence.
As for a cumulative report, you can use a waterfall chart type for that. It shows the step for each month and the steps cumulatively climb up. So that will give you both the months visually and the cumulatively for a single year.
Perhaps if you land the user on a Home Page with various charts you can get close to what you want all on one page.
------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com mark.shnier@gmail.com ------------------------------
Hi Mark, I looked at the waterfall as that of course looked soooo easy except it does not compare data.... I cannot put the previous year on the same chart against it. I need to run a comparison of two sets of data (2019 and 2020 for example)
------------------------------ Ivan Weiss ------------------------------