1 Reply Latest reply: Jun 8, 2011 9:09 PM by Johannes Sunden RSS

    Dynamic Filtering on Line Chart

      Hi, I am having an issue by trying to combine 2 things:

       

      1. Dynamic Line Chart Expression Setting
      2. 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