new expression for calculated values from chart

[#1]

Hi,

anyone able to help. I need to have another line or symbol to represent the percentage of T40_Oppo vs Total 40ft

Both of these values belong to the 'field', <Types>.

so at Feb there should show 59.8% and Jan 37.6%

thank you so much

[kaushiknsolanki]

Hi,

You can use the Column(2)/Column(1) as Expression and change the number format to % from Number Tab.

Regards,

Kaushik Solanki

[#3]

Hi,

the above does not work. I'm not sure if the expression should be changed or used as it is

[kaushiknsolanki · Accepted solution]

Hi,

You will have to change the dimension and expressions.

Your chart dimesion should be.  --- Month

Expressions should be.

1. Sum({<Types = {"T40_Opportunities"}>}Value)

2. Sum({<Types = {"Total 40ft"}>}Value)

3. Sum({<Types = {"T40_Opportunities"}>}Value) / Sum({<Types = {"Total 40ft"}>}Value)

Regards,

Kaushik Solanki

[sunny_talwar]

Would you be able to share your qvw file?

[#6]

Hi Hi,

thank you so much. I used the expressions that you gave and got the presentation in the manner needed.

cheers!

[kaushiknsolanki]

Great..

Cheers..