Creating a chart report - exclude items with a count of X (i.e. 1 or less)

Question

Hi,I'm creating a chart report that calculates number of leads by indication. I want to exclude anything with a count of 1 or less. Even excluding those with a value of zero would be useful. The problem is there are so many indications that the chart is unreadable/over crowded.Here's what the chart report set up looks like for reference...
Any ideas?Thanks!Matt------------------------------Mathew Crist------------------------------

austink · Answer

I do not use chart reports very often, or really ever. I don't have anything to test this with but could you not just add a filter that is like "# Leads &gt; 1"? Or does that end up still showing the indication but with 0 records? Sorry but again I do not ever use charts and don't really want to set this up to test it. I figure it was worth at least mentioning it though.

markshnier__you · Answer

The chart is really just the same as a summary report except the results are shown in chart form.

It is not currently possible to easily filter a summary report or a chart based on summary totals.

There is a top 10 not so easy method written up here by our forum moderator, Evan.

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=225e551a-cc59-4386-88c8-d4d6a1c12614&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

austink · Answer

I tested this last night with some different X and Y fields but fairly similar. My Y was users, and my X was # of Leads. If I added a filter for "# of Leads &gt; 1" it only showed users that had 2 or more lead records on the stacked bar chart. That seems to be exactly what ​they were looking to do here. Is there something major I am overlooking here?

markshnier__you · Answer

If the use case is that the summary report or chart is based on detail records which do not already exist in summary fields, and the problem is you cannot filter based on the totals of summary data.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mathewcrist · Answer

That is correct. I cannot filter by # of leads &gt; 1.​ Based on the "top 10 not so easy" discussion, I will look at possibly creating another table with a lookup field, and see where that takes me. I had not explored that.------------------------------Mathew Crist------------------------------

Forum Discussion

Creating a chart report - exclude items with a count of X (i.e. 1 or less)

Related Content

Report Formula - Combine some, exclude some, and include others.

Trying to create a report with an ask users filter, but with a multiselect

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Report Formulas