6 Replies Latest reply: Mar 8, 2012 12:14 PM by James Newcombe RSS

    Evaluate field values as chart expressions

    Dario Pincione

      Hi there,

       

      I've got a problem, I would like to change on-the-fly the expression on a chart.

      I've already been able to do this by:

      1) keep all the possible chart expressions in variables (1 variable = 1 chart expression)

      2) in the chart create a big IF statement based on the value of the variable behind a dropdown box.

       

      I wonder if I can (for example) create a data source (Excel or a SQL Table) containing all the expressions and evaluate them doing something like

       

      Indicator  | Formula

       

      Indicator A | ((sum({$<Anno={2009}>}[Nati - Totale]))/sum({$<Età={">=15<=50"}>}([Totale Femmine])))*1000 

       

       

      - I've tried to insert the formulas into an INLINE statement with no success.

       

      - I've tried to evaluate the formulas at loadtime with Evaluate() with no success

       

      - I've tried to insert the following expression as chart formula

       

      =$(FieldValue('Formula',FieldIndex('Indicatore',IndicatoreGrafico)))

       

      but again, no success.

       

      Any help woud be appreciated.

       

      Thanks in Advance

      Dario