You can create a Parameter for Date range, which can be used to select data points for averaging using an LOD expression as a calculated field.

Do you want to show average value by date within a certain date range? Or do you want an overall average value within a date range?

Ok, something like this?

Range 1 = date is between 1/31/2016 and 1/1/2016

Range 2 = date is between 2/1/2016 and 5/19/2016

Range 3 = date is greater than 5/19/2016

I created a new Dimension for Date Range

if [Date] <=date("1/31/2016") and [Date]>=date("1/1/2016") then 'Range 1'

elseif [Date] <=date("5/19/2016") and [Date]>=date("2/1/2016") then 'Range 2'

elseif [Date]>=date("5/20/2016") then 'Range 3'

END

That's a little confusing since you will have only one average value per date range; you cannot have a line with a single value.

Ok, so looks like you want to show the individual averages for each day then an overall average for the date range. Is that correct?

Sorry, I am not able to get the exact view you need. I am able to calculate the average value over a date range, but not able to show on the line chart the way you are looking for.

Hopefully, someone else will have an answer.

Good luck.

Hi Tze/Naveen:

The best I could get was to separate the 3 ranges and create the average line for it. When you edit the x-axis select "Independent axis ranges for each row or column".  

Though not a continuous graph you were looking for, but captures the requirement.

Thanks

This looks like a good trick!

I was thinking about calculating another field that could have the range average values, then adding it to the shelf so it could be shown on the same chart.