3 Replies Latest reply: Feb 22, 2017 1:42 AM by Sarvesh Srivastava RSS

    forcing small data values that dont show up in the bar chart

    ria Desai

      I have a bar chart where by clicking on Chart properties-->expressions-->values on data points, you can see all the values.

      Although sometimes you wont see if the value is too small. eg: grey part of the bar chart for 2017 in the pic attached.

       

      I know we can make it appear forcefully by adding formulae in presentation tab -->text in chart.  I tried but it doesn't seem to give correct answer

       

      My expressions and dimensions are as below:

      I have below dimension and expressions in the chart properties for bar chart

       

      Dimension: =if("Year" = 'FY-16' or "Year" = 'FY-17', "Fiscal Year")

       

      expr = count(if(TYPE] = 'I' and [Job ] <> 'Direct', [REASON G]))/((count({< [TYPE],[TREASON],[REASON G] = >} (if([Job ]<> 'Direct', [EMPLID]))))/2)

       

      I tried putting below in presentation tab -->text in chart . But doesnt work. basically doesnt give same value as it should give when you hover over the chart:

       

      =num (

      (

      count(if([TYPE] = 'I' and [Job] <> 'Direct' and [Year] = 'FY-17', [REASON G]))

      /

      (count({< [TYPE],[TREASON],[REASON G] = >} (if([Job ]<> 'Direct', [EMPLID]))))/2

      )

      , '#,##0.00%'

      )

       

      Can someone help here?