How to Omit Low Values
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 gra...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDrew,
no problem. But you will need to first make a summary field to a new table.
Use excel to load up a new table called Days with all the day fir the next 20 years.
Set the key field to be the date.
Make a relationship to your data table and let it create a new field called Related Date. Then rename that field to be called [Date mirror] and make it a formula field equal to your date field.
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.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
no problem. But you will need to first make a summary field to a new table.
Use excel to load up a new table called Days with all the day fir the next 20 years.
Set the key field to be the date.
Make a relationship to your data table and let it create a new field called Related Date. Then rename that field to be called [Date mirror] and make it a formula field equal to your date field.
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.
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. Call it # data records for this date.
Now, you have a field to hold Ok your chart report to to use as a filter.
Now, you have a field to hold Ok your chart report to to use as a filter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Drew,
Does the filter not solve your issue? Is the Y Axis value a Summary field or real data in the table? Can you expand on the architecture of your application? 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 Larson
Paasporter
Westlake OH
------------------------------
Does the filter not solve your issue? Is the Y Axis value a Summary field or real data in the table? Can you expand on the architecture of your application? 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 Larson
Paasporter
Westlake OH
------------------------------
