Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a chart showing cumulative records for two years. I want the y axis to show (in order) the week concerned and the year:
e.g.
01 2012
02 2012
03 2012
I have a field called Application Date which contains the date information for each record. I've tried creating a calculated dimension: =week([Application Date])&year([Application Date])
but this won't seem to sort and i get a random order of values.
Can anyone help?
Thanks
Alison
try convert it to a numeric like this: =Year*100 + week(Date)
This will give you a number that is easy to sort chronologically 201401, 201402 etc...
Use it as the dimension or just a sort order of 'expression'
try convert it to a numeric like this: =Year*100 + week(Date)
This will give you a number that is easy to sort chronologically 201401, 201402 etc...
Use it as the dimension or just a sort order of 'expression'
Try creating it as: dual(week([Application Date])&year([Application Date]), [Application Date])
dual(week([Application Date])&' '&year([Application Date]), WeekStart([Application Date]))
to get only one value at the axis for all dates within this week