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





      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?