2 Replies Latest reply: Oct 12, 2012 3:18 PM by allen.smolinski RSS

    Create filter to apply to dual axis chart

      I have a set of items which I want to filter from a field in my chart and be able to present a dual axis chart. The challenge is I have to place the field in the Dimensions or it will not display any data.

       

      For my Dimensions I have Date(Days), Field5 (but all I want is just the Date in the X-Axis)

       

      For my line Expression I have input this as the definition:    if(field5 like ('*AMT'),sum(item_COUNT),0)

      For my bar Expression I have input this as the definition:     if(field5 like ('*AMT'),sum(total amt)/1000)

       

      qvw_dualaxischart_issue.png

      as you can see the line dips for each day because I have both fields for dimensions.

       

      Any help on this would be great.

       

      Thanks,

      Allen