Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have date field YYYYWK format,I want to get WeekNumber,will Week function help here??
:
LOAD * INLINE [
YEARWEEK
201315
201318
201325
201402
201415
];
I want
WEEK
15
18
25
02
15
Thanks
Try with
LOAD YEARWEEK, Right(YEARWEEK,2) as Week;
LOAD * INLINE [
YEARWEEK
201315
201318
201325
201402
201415
];
Try with
LOAD YEARWEEK, Right(YEARWEEK,2) as Week;
LOAD * INLINE [
YEARWEEK
201315
201318
201325
201402
201415
];
Thanks..its fine...but in above Inline Table we have 15th week for both Years.
I want to show week Values in Y Axis like below,How we can do it
--------------------------------------------Y
15 18 25 02 15
Thanks
I'm assuming you aren't loading from an inline table? Try:
Right(YEARWEEK,2) as WeekOfYear
yes I am loading it from Database,
I would like to get
WEEK Values like WK15,WK18,WK25,WK02,WK15..
Thanks
In your table if week is for all years then you get week for all years other wise you can use the master calendar.
and for week like this way 15 18 25 02 15
You can achieve this by using the pivot table and add the dimension week and then click on the week dimension and drag it to the right hand side upper top corner of the chart then you get week like you ask.
See the attached pivot sample