Previous week & current week

MK9885 · ‎2019-01-16

Hi,

I'm trying to build a KPI. And bar chart for last 8 weeks

KPI should show me current week and previous week

Bar chart should show current week + 7 previous weeks

Everything was working fine until last day of dec falls under week 1 of 2019 that would make week 53 and week 1 together.

My expression doesn't work any more

I used max of week in set, max of date, etc etc but nothing seem to work...

Anyone know how to get 12/31 to 01/06 data with an expression?

MK9885 · ‎2019-01-16

Got it fixed.
thanks for any help.
If you still like to share your solution please do so.

Frank_Hartmann · ‎2019-01-16

have a look at weekend function!
e.g.
=weekend('31.12.2018')

the formula should show 06.01.2019 as result!