topic Re: Comparing day quantities to previous years using a table in Sense. in Connectivity & Data Prep

Comparing day quantities to previous years using a table in Sense.

Tue, 15 Mar 2016 04:17:55 GMT

Hi:

I'm having problems trying to solve a problem similar to this. Giving this data:

YEAR-MONTH	DAY	QTY
201501	10	100
201501	15	200
201501	20	300
201401	05	100
201401	15	200
201401	20	300
201401	30	400
201301	05	200
201301	10	150
201201	20	200
201201	22	250

Need to get this one if I select YEAR-MONTH = 201501

TOTAL PER DAY	TOTAL PER DAY	TOTAL DAY	TOTAL	TOTAL	AVG	DIF
DAYS	YEAR-MONTH 201501	YEAR-MONTH 201401	YEAR-MONTH 201301	2 LAST YEARS	2 LAST YEARS	YEAR 0 - AVG 2 YEARS
05	0	100	200	300	150	-150
10	100	0	150	250	125	-25
15	200	200	0	400	200	0
20	300	300	200	800	400	-100
22	0	0	250	250	125	-125
30	0	400	0	400	200	-200

Of course if I need to select other year-month previous years are recalculated using 2 previous years and same month.

I'm attaching excel file with data and desired output.

Any ideas?

Re: Comparing day quantities to previous years using a table in Sense.

sunny_talwar — Tue, 15 Mar 2016 09:31:06 GMT

Not sure if this is what you want (and there are certain things I don't understand such as Avg for last two years is based on last 3 year numbers divided by 2 and 2013 includes numbers from 2012, but assuming these were sample error, see if the attached helps)

Re: Comparing day quantities to previous years using a table in Sense.

Tue, 15 Mar 2016 18:46:13 GMT

Hi Sunny:

Some tips you gave me, but I have some problems trying to execute your qvw file and also reproducing into Sense.

This is what I got when trying to see your qvw file. A memory error.

And here is also an screenshot of Sense version using same load and formula values:

Im not getting same view like in QV.