Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
text( field ) gives an "No numeric values on x-axis" message.
Did you consider using the week() function?
You can use something like: year(datefield) & '/' & week(datefield)
as dimension.
Hi,
Try like this
LOAD
*,
Dual(Year(DateFieldName) & '/' & Week(DateFieldName), WeekStart(DateFieldName)) AS WeekYear
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
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.
Milka ,
Try this:
year(Datefield) & ' / ' & week(Datefield) as Week_Number
Thanks,
AS