Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
See attached qvw.
wow, brilliant, thank you very much
One more thing, your solution return week no. '1', why ?
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.