Adding a trend line

[tvisha]

Hi,

I have a bar chart which shows cases based on category. I want to add a  trend line which will show cases open for more than 12 days (Chart below).  I am trying to add a reference line, but it is not working. Not sure what I am doing wrong. 

My dimensions and measures for first graph,

[kaushiknsolanki]

Try using a combo chart instead of a bar chart.

A combo chart will allow you to add Bar and a Line in a single chart with the different axis.

[tvisha]

I guess I added that, will check thank you