Forum Discussion

LeonLeon's avatar
LeonLeon
Qrew Member
9 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
Moderator
6 years ago
Hi John,

Unfortunately that is a very old link that lead to the Forums we had when we were still part of Intuit that have been retired. I believe though that is was directing to this conversation:

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30741&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer


------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
JohnNorwood's avatar
JohnNorwood
Qrew Member
6 years ago
Thanks, Evan. Before I go down this rabbit hole, by chance in the time that has elapsed since the original post, do you know if a simpler solution come to light? I just want a bar chart with the x axis dates grouped by week to display zero rather than skipping the week if there are no matching records.

------------------------------
John Norwood
------------------------------
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    6 years ago
    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
      6 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
        6 years ago
        Thanks, Mark. I think this might be the easiest approach and should work for my application.

        ------------------------------
        John Norwood
        ------------------------------