Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
You can use the Column(2)/Column(1) as Expression and change the number format to % from Number Tab.
Regards,
Kaushik Solanki
Hi,
the above does not work. I'm not sure if the expression should be changed or used as it is
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
Would you be able to share your qvw file?
Hi Hi,
thank you so much. I used the expressions that you gave and got the presentation in the manner needed.
cheers!
Great..
Cheers..