Hi, I am having an issue by trying to combine 2 things:
- Dynamic Line Chart Expression Setting
- Information filtering
Here is the scenario:
I have a Line chart that currently is evaluating it's only expression dynamically with he following code:
=$(=IntervalExpression) <-- (Works)
In other pivot charts I am able to show information by using both Aggr funtion and Filtering with the help of set analysis on its only calculated dimension:
Example
=AGGR
(
MAX( {$<HeaderStartDate={">=$(varCalendarStartDateTZ)<=$(varCalendarEndDateTZ)"}>}
DISTINCT ContactID ),
ContactID
) <---(Works)
The problem is that I need to filter a Line chart's displayed information and also change its expression dynamically, but when I try to combine both approaches, the expression is not computable
=AGGR
(
MAX( {$<HeaderStartDate={">=$(varCalendarStartDateTZ)<=$(varCalendarEndDateTZ)"}>}
ContactID ),
$(=IntervalExpression)
) <--(Doesnt work)
Any Suggestions?
Thanks in advance for you time!
-Ed
