QuickBase Reports Help

Question

Hi all, new to QuickBase but not new to database tools.

I'm trying to build a specific report within QuickBase. In Tableau it's called a Bowling Sheet. A non-propriety example looks like this:

https://www.allaboutlean.com/wp-content/uploads/2025/01/Bowler-Chart-Example3.png

Ive been able to get sort of close in QuickBase by using the Summary Report, and I can group columns by Month to achieve the same result, but my issue is that it's giving me a COUNT of the data that's being reported instead of the actual value of that data. I'm sure it's something stupid/easy that I'm overlooking, but I'm stumped.

Any help would be appreciated.

markshnier__you · Answer

Well in the section for configuring the Summary Report for the "Summarize Data" section, it lets you select what to summarize.&nbsp; So select the field(s)&nbsp; that you want to summarize, typically selecting by Totals. You can hover to the right to add more fields to summarize.

jclayborn · Answer

Maybe that's where I'm getting this wrong. If you look at the attached screenshot, I don't actually want to summarize anything, per se. So the fields that show "1" for the goal counts should display the actual reported value, not the count of values.&nbsp;

markshnier__you · Answer

I think I need some help understanding your question. For example, when I look in your Screenshot for "Percent exceeding ....... medicare mean and there is a 1 in July 2025, what are you expecting to see there?

denin · Answer

I think the issue is it's showing you "1" like 1 total record, rather than the value contained in the field on that record - right? Maybe change "Summarize By" to Totals in the settings for that report:

If that doesn't work, I think you need a separate formula field to get the values and display them.

Forum Discussion

QuickBase Reports Help

4 Replies

Related Content

Quickbase Resources

Getting Familiar with Quickbase Navigation

Are You an Accidental Quickbase Admin?

Report Dynamic filters

QuickBase Scripts