Set analysis is overwriting selection filters

[#1]

Hi, I am running into an issue where my Set Analysis Filter is overwriting the Current Selections on the dashboard.

I have a table that only counts orders where we received payment on. However, if I want to filter on high paid orders, it doesn't work correctly.

If I have a filter that says only show orders with a payments of > 500, it isn't getting applied to the below set analysis.

Set analysis:

=count({$<[Order Total Payments] = {"$(= '> 0')"}>}Distinct [Order Number])

The set analysis counts all orders over $0, and ignores my $500 filter. Is this expected behavior? Any ideas on a work around? I always expected set analysis to work with the current selections if the $ was applied.

Thanks

[sunny_talwar · Accepted solution]

May be try this expession:

=Count({$<[Order Total Payments] *= {"$(= '> 0')"}>}Distinct [Order Number])

[#3]

Yep, that did the trick. Thank you! Could you explain what the * before the equal sign does? I haven't seen that syntax before.

[sunny_talwar]

* is used for intersection. In this particular case, it is looking for intersection between your current selection and and your specified modifier (>=0)

Read about this here:

Implicit Set Operators

[#5]

That blog post was very informative. Thanks!