Week number (formatted as yyyy/ww) as dimension

[#1]

Hi,

I'm trying to use week number on x-axis, but I want the format to be yyyy/ww. Is there a way to achieve this?

I've created a dual where the text part is properly formatted year and week number, and the numeric value is year * 100 + weekNo, but this gives me the numeric value on x-axis instead of the text value that I want.

[morganaaron]

May be a silly question, but have you tried using Text([Your Field]) as the dimension if you're holding it as a dual field? Or is there difficulty in relating it to a genuine week number?

[#3]

text( field ) gives an "No numeric values on x-axis" message.

[Anonymous]

Did you consider using the week() function?

You can use something like: year(datefield) & '/' & week(datefield)

as dimension.

[jagan]

Hi,

Try like this

LOAD

*,

Dual(Year(DateFieldName) & '/' & Week(DateFieldName), WeekStart(DateFieldName)) AS WeekYear

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

This is how I am loading this in my script:

date(datefield,'YYYY')&'-'&num(week(datefield),'00') as Year_WeekNum.

If you are using this calculation in the chart dimension as calculated dimension it should also work.

[amit_saini]

Milka ,

Try this:

year(Datefield) & ' / ' &  week(Datefield) as Week_Number

Thanks,

AS