Discussions

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 of showing 0. The result is that visually, all months appear to have positive data, which is misleading. I want to show that there are months with $0 totals.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

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

Original Message:
Sent: 11-15-2019 10:49
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

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

Original Message:
Sent: 11-15-2019 11:14
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:49
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

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

Original Message:
Sent: 11-15-2019 12:47
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 11:14
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:49
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

Thanks, Mark. I think this might be the easiest approach and should work for my application.

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

Original Message:
Sent: 11-15-2019 13:01
From: Mark Shnier (YQC)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 12:47
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 11:14
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:49
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

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

Original Message:
Sent: 11-15-2019 17:41
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

Thanks, Mark. I think this might be the easiest approach and should work for my application.

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

Original Message:
Sent: 11-15-2019 13:01
From: Mark Shnier (YQC)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 12:47
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 11:14
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:49
From: Evan Martinez
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

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

Original Message:
Sent: 11-15-2019 10:36
From: John Norwood
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

I'm trying to solve this exact same problem and would like to look at the example referenced by https://quickbase-community.intuit.com/questions/1447093 , but following the link just takes me back to https://community.quickbase.com/home. Is there any more information available on the solution or relevant examples?

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

Original Message:
Sent: 10-14-2016 20:31
From: _anom Diebolt)
Subject: QuickBase bar chart showing $ over time skips blank months instead of displaying months without $ as 0.

You have to (1) generate the chart using script or (2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows  you the general technique of how to modify a QuickBase rendered chart:

What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093
it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into. 
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.

Hi, thanks very much for reviewing my question and providing a helpful response. Your solution looks like something I could figure out eventually (probably with more help) but given time constraints, I'm going to live without it for now. It's good to know that it is possible but would require some custom work. Thanks again.

Leon, the other simpler option would be to enter dummy data with zero sales dollars for every month on your chart.

Yes, thank you! That also works (I checked), although doing that would complicate my project counts, so I'm not going to go that route. I'll survive. I appreciate the ideas!

To encourage you to pursue a script solution to patch up your chart I wrote this Haiku:

QuickBase data
script, that chart,
To the zero in the financial.

http://www.languageisavirus.com/interactive-haiku-generator.html

Hi, I'm having a similar issue, rather than dollars my chart shows count of activities in another table. I have no way to input a zero value for that. Is there another way I can achieve the same outcome?

I wrote this Haiku to encourage you to pursue a script solution:

common script 
common, that problem,
To the script in the outcome.

Thank you for that, but I don't know how to write script

No problem. I don't really know how to write Haiku - I have to use a generator.

In any event, here is the updated link to the old post in the new forum:

What Chart Enhancements Do You Need?
https://community.quickbase.com/quickbase/topics/what-chart-enhancements-do-you-need

It looks like I never created an example to patch the missing data but there are two similar examples that (1) change the scale and (2) accumulate data of a previously rendered chart. It would be easy to use the same general technique to patch missing data although I would have to think about how to do it in a general way. Maybe I will create a demo - I will put it on my todo list again.

If you need a more immediate solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt">https://getsatisfaction.com/people/dandiebolt">https://getsatisfaction.com/people/dandiebolt