How to Omit Low Values

Question

Hi there,

I've got a report I run that shows me certain tickets for a given day. However, I don't want to include in the graph any count which results in less than 5. Here is what my graph looks like now:
I'm trying to figure out how to remove those low values as they are outliers and skew the graph a bit. ------------------------------Drew Woods------------------------------

brandondrake · Answer

Hello Drew,&nbsp;In the graph report, you should be able to select a filter and tell it to only show when the number of tickets is great than 5.&nbsp;

------------------------------Brandon Drake JHI GroupMonroeville OH------------------------------

donlarson · Answer

Drew,Is this a Line Graph?If so you can add a filter to require that the value is greater than a specific threshold.
------------------------------Don LarsonPaasporterWestlake OH------------------------------

markshnier__you · Answer

Drew,no problem. But you will need to first make a summary field to a new table.&nbsp;Use excel to load up a new table called Days with all the day fir the next 20 years.&nbsp;Set the key field to be the date.&nbsp;Make a relationship to your data &nbsp;table and let it create a new field called Related Date. &nbsp;Then rename that field to be called [Date mirror] and make it a formula field equal to your date field.&nbsp;&nbsp;The reason for going through this extra step is to not disturb the way your dates are completed now in your data table, where there is a calendar drop-down.&nbsp;
Then on that relationship make a summary of the number of data records for that date and look it up down to the child data records table. &nbsp;Call it # data records for this date.&nbsp;Now, you have a field to hold Ok your chart report to to use as a filter.&nbsp;

​​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

donlarson · Answer

Drew,Does the filter not solve your issue?&nbsp; &nbsp; Is the Y Axis value a Summary field or real data in the table?&nbsp;Can you expand on the architecture of your application?&nbsp; Is the addition of the new Date Table to your app as Mark recommended creating the visualization your end users need?I am trying to understand the dilemma more clearly and how to navigate the Quick Base reporting engine to get the desired result.------------------------------Don LarsonPaasporterWestlake OH------------------------------

Forum Discussion

How to Omit Low Values

Related Content

Find and Replace Field Values

Using AND with Null values

Jinja If statement equals field value

Grabbing value between 2 fields

Color Coding based on field value