Forum Discussion

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...

reports and charts

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

Icon for Qrew Legend rank

Qrew 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
Qrew Member
5 years ago
Add a lookup field? I'm exactly not sure what you are suggesting.

Thanks,

Matt

------------------------------
Mathew Crist
------------------------------
- MarkShnier__You
  Qrew 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
  ------------------------------
- MathewCrist
  Qrew Member
  5 years ago
  I think the issue is (something I just realized) that the leads table has a field called indication, and studies table also has a field called indication. There's no relationship built in to connect the two. So the count is coming solely from within the leads table, at least I think so. Sorry for the confusion.
  
  ------------------------------
  Mathew Crist
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Well the only way I can think to filter the results as if you had a table which was a list of all the unique indications.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------