Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Block Chart.
For current month I need weekly data.
For example i have June as my current month
I need Wk22 Wk23 Wk24 Wk25 Wk26 Wk27 data in this month.
or else only working weeks i.e Wk 23 wK24 wK25 wK26
This should be in dimension and Number of hours worked will be in expression(Sum(Hours)).
Data:
Date | Hours |
---|---|
2/6/2014 | 9 |
3/6/2014 | 9|
4/6/2014 | 9|
5/6/2014 | 9|
6/6/2014 | 9|
7/6/2014 | 9 |
8/6/2014 | 9 |
Do you have Master Calendar built?
If yes then you can use the Weekfield there
Check and let me kno
I have used
'Wk'&week(Date) as Weekly
in my script.
Please let me know the proceeding.
I need only 4 weeks(i mean i need to restrict vales in dimension for current month only)
'Wk'&week(Date) as Weekly
Is it not working?
Try like:
If(Month(Today())=Month(Date), 'Wk'&week(Date) ) as Weekly
That is working.
But i need only on month's weeks to be displayed.
I need restriction on Weekly field for current month only(or else it will display each and every week whose data is present)