Report - Need to filter Data values on x axis

Question

I have a report that shows number of leads on the x axis for the value of Y (which in this case is 'indication'). I can't figure out how to hide anything with a value of 0.&nbsp;

Does this need to be a report formula, or should I be able to do this from the filter? Either way, it seems like there must be a simple solution and so far I haven't figured it out.------------------------------Mathew Crist------------------------------

markshnier__you · Answer

The only way to do &nbsp;this is to have a summary field on the indication table for the number of records. Then you would be able to look that up down to the details table and filter on that.

However the problem is going to be that if there are other filters on the report or time periods involved in the summary field is not going to &nbsp;recognize that. So currently it's not that easy to do.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mathewcrist · Answer

Hi Mark, thanks for your reply. This was helpful in showing me how to work with summary fields. I'm working on getting the right data set to show, but was able to filter out values of 0.

Thanks,

Matt

------------------------------
Mathew Crist
------------------------------

markshnier__you · Answer

Did you lookup the #&nbsp;of leads down to the child table?&nbsp; Then&nbsp; it will be available as a filter.​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mathewcrist · Answer

Add a lookup field? I'm exactly not sure what you are suggesting.Thanks,Matt------------------------------Mathew Crist------------------------------

markshnier__you · Answer

You said that your relationship had a summary to count the number of detail records for each Indication.&nbsp; I suggesting that you look that up down to the detail records and then it will be available as a filter.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Report - Need to filter Data values on x axis

Related Content

Find and Replace Field Values

Embedded Grid Edit Report Pre-filtered Conditional Dropdown

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

Using AND with Null values

Jinja If statement equals field value