Configuring distribution of reports to multiple recipients
Issue
How to configure Advanced reports to support multiple values with separator?
Solution
Advanced report does not support multiple values with separator.
If required multiple values then each value should be in separate row.
All non-empty values from one column are combined and used as filter with OR.
Different columns are user in filter with AND.
1. if a user wants to send report to multiple users, then each e-mail should be in separate row:
2. If multiple values for multiple filters should be applied then each value should be in separate row (but values from different columns can be mixed).
Here are some samples:
A)
ProductID, Country
10, USA
11, UK
B)
ProductID, Country
10, UK
11, USA
C)
ProductID, Country
10, ''
11, ''
'', UK
'', USA
In all these samples the result will be the same:
fitler for productID will be union, empty or NULL values ignored: (10 Or 11), for Country too: (UK OR USA) and two columns will be combined with AND. So the result will be:
(ProductID = 10 OR ProductID = 11) and (Country = USA or Country = UK)
About combine different conditions by rows like “ProductID = 10 AND Country = USA” OR “ProductID = 11 AND Country = UK” - this is not possible.
Level of Complexity
Moderate
Applies to
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
Insight | All | N/A | N/A | N/A |
References
Add any references to other internal or external articles
Article # 3036320