Week 52 in Jan

[#1]

Dear All,

I have a cyclic group year/month/day in a chart and with the current calendar setting 1 Jan 2017 falls into week 52. My issue is when filtering data for Jan it shows week 52 as well. How can I just show week 52 in Dec 20166 and not in Jan2017 please?

Thanks

Neda

[adamdavi3s · Accepted solution]

Hi Neda,

Just apply a similar logic when you generate your master calendar

So something like

=if(month(OrderDate)=1 and week(OrderDate)=52,0, 1) as weekcheckflag

However you'll still need to alter your expressions:

sum({<weekcheckflag={'1'}>} value)

Or select the flag as a default.

Just as a random aside, can I suggest keeping all expressions in variables and then the definitions of those variables in a file, this way it makes life a lot easier when you need to make this sort of change