Forum Discussion

LeonLeon's avatar
LeonLeon
Qrew Member
8 years ago

QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I have a QuickBase bar chart showing financial totals, grouped by month, based on a date field. The problem: months w/o any financial data (this happens in the slow winter season) are skipped instead ...
reports and charts
Tables and fields
EvanMartinez's avatar
EvanMartinez
Qrew Elite
Hi John,

As of right now that would still be the case for sorting and grouping on a report. The reporting pulls from the existing records to set up the groups and doesn't pull a week in this case that has no records. So for example if you didn't have records for the month of May this year a report for the year by week would be missing all of May.  The reporting is just optimized for data points with records.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

You might be able to get a chart working by loading up a table of Sunday's  say for the next 20 years of weeks, so a thousand records.

Then summarize your real data into the weekly buckets. 

I know that means you won't be able to have dynamic filters but maybe you can have a series of charts that still basically give you the charts  you need.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • JohnNorwood's avatar
    JohnNorwood
    Qrew Member
    5 years ago
    Thanks, Mark. I think this might be the easiest approach and should work for my application.

    ------------------------------
    John Norwood
    ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Commander
      5 years ago
      John,

      Have you considered using a BI/BA tool like Tableau?  It is not as easy as a Quick Base report but you have a lot more control.  


      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------