Budget Service Hours vs Actual Monthly Hours

[HannahThompson]

Hi, Hoping someone can help me! I am using the browser version of BI and i have created a chart to show me upcoming service PPM hours for the future months. I am hoping to be able to create some form of trend line to show the actual calendar hours within that month so we can see our availability. The chart i am using is a stacked column chart. Hoping someone can help as i cannot figure it out!  TIA 

[HannahThompson]

Thank you for responding, i have attached a picture of the chart i have created. The blue line i have drawn on is something i am hoping to achieve with the blue line being the actual hours for that calendar month. I think the issue i am having is the data headers i have available are all pulled through from our service software - we use Protean if that helps. I am not sure its something i am able to achieve within asking them to help and it be a chargeable exercise. 

[vanessafvg]

hannah can you share what your data looks like?  its hard to know how to help without seeing that.  i mean what you need to use the line and stacked column chart and then place the potential capacity on the line,  not sure i understand your issue with the header.  

[HannahThompson]

Hi, Sorry this is all a bit new to me! So the only 'data' i currently have available is what is in the fields in the picture attached. I can confirm the chart is a lined and stacked chart however i dont see what 'header' i can use in the line value field to give me what i want. As i said i think i might need to go to our service software people to make this information available. 

[vanessafvg]

Hi hannah

please can you provide some screen shots of what your data looks like, the structure,  with an example of what you are expecting.