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