Moving Report Filter Groups
I can't figure out how to move an entire filter group in a report. I can move a condition into and out of a group but not move the whole group.
Best Answer
-
Genevieve P. Employee Admin
Hi@Sara H
With filters the order does not matter for priority as you're either filtering or not filtering out rows. For example, if you filter out all rows that say "Value 1"and"Value 2" then no matter what order you put those in, both Value 1 and 2 will be filtered out. (That said, theSortorder in a Report does look at location for priority, you're correct!)
What organizes aFiltersetting will be the AND or OR statements that you see on the right in terms of grouping the different filter statements together, does that make sense?
Cheers,
Genevieve
Answers
-
Genevieve P. Employee Admin
Hi@Sara H
Can you post a screen capture of your current filters and explain what it is you're looking to do?
If you're trying to merge two filter groups together, you may need to drag each individual statement into a single group, one at a time.
Cheers,
Genevieve
-
Sara H ✭✭✭
@Genevieve P.I have multiple groups of filters and I wanted to move the one on the bottom up on the list. I understood that in a report the higher the filter group, the more it takes priority. Maybe it doesn't matter if they are all conditionally OR instead of AND?
-
Genevieve P. Employee Admin
Hi@Sara H
With filters the order does not matter for priority as you're either filtering or not filtering out rows. For example, if you filter out all rows that say "Value 1"and"Value 2" then no matter what order you put those in, both Value 1 and 2 will be filtered out. (That said, theSortorder in a Report does look at location for priority, you're correct!)
What organizes aFiltersetting will be the AND or OR statements that you see on the right in terms of grouping the different filter statements together, does that make sense?
Cheers,
Genevieve
-
Sara H ✭✭✭
@Genevieve P.Thank you!
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/105444/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/105444/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>