Forum Discussion

MathewCrist's avatar
MathewCrist
Qrew Member
5 years ago

Report - Need to filter Data values on x axis

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.  Does this...
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The only way to do  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  recognize that. So currently it's not that easy to do. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MathewCrist's avatar
MathewCrist
Qrew Member
5 years ago
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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Did you lookup the # of leads down to the child table?  Then  it will be available as a filter.​

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MathewCrist's avatar
      MathewCrist
      Qrew Member
      5 years ago
      Add a lookup field? I'm exactly not sure what you are suggesting.

      Thanks,

      Matt

      ------------------------------
      Mathew Crist
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        You said that your relationship had a summary to count the number of detail records for each Indication.  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 Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------