Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this expession:
=Count({$<[Order Total Payments] *= {"$(= '> 0')"}>}Distinct [Order Number])
May be try this expession:
=Count({$<[Order Total Payments] *= {"$(= '> 0')"}>}Distinct [Order Number])
Yep, that did the trick. Thank you! Could you explain what the * before the equal sign does? I haven't seen that syntax before.
* 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:
That blog post was very informative. Thanks!