Summary Report Filters

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
  • (Edited)
I am having difficulty on a Summary Report and multiple filters.
I get exactly what I want when selecting the Status




But when I add in the secondary layer of filters to get to the ROM's & Status I want..

It returns the following... I am clueless why this is happeningĀ 



Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Can you say in words what you want the 2nd set of filters to do?
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
Mark the second set of filters is to get down to the ROM. Basically I want to filter by the status of the project (1) and then by the ROM name (2).
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
Mark... I do not remember having to break down the filters this way, but finally figured it out
I had to keep segregating the parameters away from each other


(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,028 Points 50k badge 2x thumb
Great, so you are good now.
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
Yes, thank you. But it does lead to another question, if I may. On the last screen shot; it is stating where the Start Date is during the next 1 week. I am okay with this one.
But what if I wanted the Start Date to be 2 Weeks? Don't want week 1 & 2 together. (is what during the next 2 week(s) gives me)
Example: 1 Week is 8/13/2018 and Week 2 would be 8/20/2018
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,028 Points 50k badge 2x thumb
if you want to include the week after next week, but not next week, then you use the two filters

date is during the next 2 weeks
date is not during the next 1 week.
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
You are DA MAN! Thanks Mark I do appreciate it!