Need weeks output of current month

[saumyashah90]

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:

9999

Date	Hours
2/6/2014	9
3/6/2014
4/6/2014
5/6/2014
6/6/2014
7/6/2014	9
8/6/2014	9

[Anonymous]

Do you have Master Calendar built?

If yes then you can use the Weekfield there

Check and let me kno

[saumyashah90]

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)

[Anonymous]

'Wk'&week(Date) as Weekly

Is it not working?

[tresesco · Accepted solution]

Try like:

If(Month(Today())=Month(Date), 'Wk'&week(Date) ) as Weekly

[saumyashah90]

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)