Its posible to change method agregation in calculated value with property

[Martin Campos]

I have this in a bar chart to calculate the sum of revenue for one year in the company

 

sum([Revenue])

but I want to change the sum() for avg() with some function, its posible with a property or filter I want to do this dinamically, I dont want to change manual.

 

Its posible

 

Thanks

[Gaia Paolini]

You can define the function as a string document property in a dropdown action control within a textarea.

Say your document property is called ${axis} and takes values Sum or Avg (using Set property value through: Fixed values)

Then change the custom expression of your axis to

${axis}([Revenue])

[Martin Campos]

Thank you!! it works, butI put a property in list box and I assign a property in a drop down list these two expressions:Revenue  - Expresion ( Sum(If([Origen de los datos]="BO",[NET_AFI_REVENUE_PER_ROOM])) as [$ OTB],

Sum([FACT_BUDGET_FORECAST_VIEW].[REVENUE]) as [$ Forecast])I want to choose only one of two custom expresion to kpi chart because send me a message: "multiple continuous expressions are not allowed" Thanks

[Gaia Paolini]

I see you added this as a new question, but I don't understand it. 

 

https://community.tibco.com/questions/its-posible-take-one-custom-expressions-we-create