22 Replies Latest reply: Apr 5, 2016 5:26 AM by Kaushik Solanki RSS

    how to get percentage on bars

    naveen kumar

      Hello All,

      is it possible to show both value and percentage on each bar in bar chart..

       

      dimension:category ,decision

      expression i wrote :=count({$<Category={'Smelting'},MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

       

      i am able to get value on each bar now i need percentage of each bar from total .As you see in screen short total is:50718, and this value is divided in to three diff bars    1)43512

                                                        6626

                                                          580

                                                    50718

       

      i tried by enable relative option but i get only percentage but i need both value and percentage ,

      shall i write another expression for percentage and change chart to combo chart will it work?

       

       

       

      thanks

      naveen