1 Reply Latest reply on Oct 3, 2016 3:15 PM by hannah.johnson

# Week to week and compare year to week beginning at the 01/01

Hey,

we've problems with date intervalls.

Introduction:

At first we compare weeknumber x 2016 with the same weeknumber 2015, therefore we created a parameter so the user can choose the weeknumber and get the KPIs for them.

Problem:

We want columns in the same dashboard where the user sees the KPIs for the year to week:  Mindates are 01/01/2015 and 01/01/2016 and maxdates the last day of the week (the user chosen in parameter) 2016 and day 2015.

Example:

isoweek 36 2016 (05.09.2016-11.09.2016) vs isoweek 36 2015 (31.08.2015-6.09.2016)

year to week comparing

01.01.2016-11.09.2016 vs 01.01.2015-11.09.2015

Has anyone an idea how to solve this?

Grettings from Cologne,

Anna

• ###### 1. Re: Week to week and compare year to week beginning at the 01/01

Hi Anna,

If you are filtering the view to just display Week 36 as a column, but still want to include data from other parts of the year, you can filter the view without filtering the underlying data so that you still have the underlying data for the KPI measure. Information about "filtering the view without filtering the underlying data" can be found here:

So if you are filtering the view to just display Week 36, the filter formula would look something like this:

LOOKUP(SUM(WEEK(<date>)),0) = [<parameter>]

Then, the KPI value may look something like this:

SUM(

IF WEEK(<date>) >= 1 AND WEEK(<date>) <= [<parameter>]

THEN <KPI>

END

)

Cheers,

Hannah