Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Its posible to change method agregation in calculated value with property


Martin Campos

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

×
×
  • Create New...