Week to Date Range on chart x-axis

[haymarketpaul]

Hi All

QV11 SR1

I have a chart that happily displays Number of User Logins by Week Number (see attached)

Instead of displaying the week number on the x axis i would like to display the date range for that week.

Week 1 starts on the 17th Sept 2012.

For example in the attached qvw instead of week 1 on the x axis it would display 17/09/2012 - 23/09/2012 and so on

eg...

week 2     -    24/09/2012 - 30/09/2012

week 3     -    01/10/2012 - 07/10/2012

week 4     -    08/10/2012 - 14/10/2012

etc

Any ideas welcome

[Gysbert_Wassenaar · Accepted solution]

Try changing the dimension Week Number to the expression:

=dual(WeekStart([LoginDate]) & ' - ' & WeekEnd([LoginDate]),[Week Number])

BTW, it looks pretty horrible in the chart. You're better off with the weeknumbers imho. In a table it'd be ok.

[haymarketpaul]

Thanks for the reply - works perfectly.

Yes i'm going to display in a table which like you say will look much nicer.