stacked chart with vertical secondary axis series

• Nomvula

  Hall of Fame

  Points: 3778

  More actions

  March 22, 2017 at 5:29 am

  #321786

  Hi
  I have a stacked chart I need to calculate attainment percentage but i'm getting extra labels on the trend which are 0 %.
  the formula I used for the label is :

  CStr(((Sum(Fields!CompletedOnTime.Value) * 100) / CountDistinct(Fields!Code.Value,"Month_Year2"), 1)) + "%")
  if you look in the table these fields are OnTime/ Total Scheduled so the percentage on the graph should be the same as in the table. see the screenshot of my chart, the design and preview.
  

  

• Thom A

  SSC Guru

  Points: 99130

  More actions

  March 22, 2017 at 5:43 am

  #1934274

  Double post of https://www.sqlservercentral.com/Forums/1865933/stacked-chart-with-vertical-secondary-axis-series. Please only make one topic per question 🙂

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk