Problem with creating chart

[#1]

Hi i have a table as presented below :

Installation	Date Start	Date Finish
3500	01.08.2014	31.12.2014
200	02.09.2014	23.11.2014
768	12.07.2014	10.10.2014
100	01.10.2014	01.12.2014
300	01.09.2014	11.11.2014

I want to create a chart in which i would have as a dimension number of week (on X axis : weeks between min date from Date Start and max date from Date Finish) and on Y axis average amount of installation in particular week. I don't know how to do this because i have just date start/finish and i don't have weeks between this dates 😕 Is there any way ?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

wow, brilliant, thank you very much

[#4]

One more thing, your solution return week no. '1', why ?

[Gysbert_Wassenaar]

The last three days of december 2014 are part of week 1 of 2015. In the attached qvw I've changed the sort order of the weeks to reflect this.