Aggregation function is disabled when adding a second filter

Question & Answer
,
1

Hi:)
I am trying to add a combination of filters by using the Add Filter Condition option.
When i try to add the second filter it doesn’t let me choose aggregation function, see att. screenshot.
When I try to choose the aggregated function and a date filter as the second it doesn’t let me either.
What do you suggest for me to do?
What i am trying to achieve is applying different filters on different months (aggregated groups). for example: filter all rows when Sep Volume>2000 and August volume<3000

Thank you

Screenshot 2024-09-10 at 2.56.30 PM
Screenshot 2024-09-10 at 2.56.30 PM436×1366 48.2 KB

Tal

2

Hi @tal,
This is currently a limitation with the current filtering options available in QuickSight.
One work around that could potentially work for your case; create a calculated field for each month so that you can set a filter on those instead.
Your calculated field may look like this (September)

ifelse(
  extract('MM', {date_field}) = 9,
  sum({volume_field}),
  null
)

You can then follow same process for August. Then in your visual, you can setup a filter using these calculated fields instead and set the filtering option to your desired volume amount.

Let me know if this works for your case or if you have any additional questions!

1 Like
3

I will try.
Thank you for the creative thought:)

1 Like
4

Hi @tal,
Following up here to see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @tal,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.

Thank you!

6

Thank you Brett.
Your tip. was helpful. You can resolve this.

1 Like