7 Replies Latest reply: May 17, 2011 7:48 AM by Deepak Vadithala RSS

    Show Value on Bar Chart (Conditional data value based on field selection)

    Deepak Vadithala

      Dear All,


      I am using a stacked bar chart and I wanted to display the "Values on Data Points" - conditionally. If I select a value from a field the data points should show and if I dont select anything the chart should hide them.



      I thought I can use the below expression in the (Sub expression - Show Value), however I had realised this works only for the line chart and does not work on bar chart. Here is the expression...


      =IF( GetSelectedCount(MyField) > 0 , 0, 1)


      Please can someone help me on this?


      Original Requirement :

      The original requirement is to show 100% across each hour and not 5.56%. I can't seem to figure how to get this done, so I thought I would hide 5.56% and show the values when there is selection.


      Hope this is making sense.


      Thanks in advance.


      Cheers - DV