5 Replies Latest reply: Dec 18, 2012 10:54 AM by Luis Obedé RSS

    Calculated dimensions in scattered chart

      Hi Community.


      After some months following the forum I write my first post hoping someone can help.


      I have a large document containing sales data. I defined an expression to calculate a "segment" to each client based on the average monthly sales range for the selected period (months).


      I´m trying to draw a graph (not sure scattered/grid) to represent segments on the X axis. Y axis should represent total sales for clients of each segment and bubble diameter represents number of clients in the segment.


      The X axis (segments) is defined using a calculated dimension, and maybe this is my problem. I can´t define an expression for Y axis using segment values.


      I thought about defining segments in script, but that would make my graph static.


      I attach a sample QVW to better explain the scenario.


      Hope someone has been in a similar situation and can help where I´m absolutely stuck.


      Thank you in advance.