Comparing holiday periods

[dafnis14]

Hi,

I have a request to generate a similar report to the one attached below (Excel).

The idea is to compare a selected holiday period to the same holiday in a previous year.

Another request is to enable the user to define a number of days before and after the holiday period. Which means that the calculations have to be on the fly, and not in script.

I was thinking about using alternate states, but not sure whether this is a good direction.

I would appreciate some guidelines.

  Thanks!

Message was edited by: Dafnis X

[jpenuliar]

Hi,

Can you post sample data

[dafnis14]

Hi,

I just did..

Thanks!

[jpenuliar]

the attachment is basically the report you want to achieve,

Do you have source data, table/s where the report takes data from?

[dafnis14]

Hi Jonathan,

You are right. I should have attached real data. I'll do that later.

But regardless of the holidays – is it possible to generate such a chart at all?

Thanks!

[jpenuliar]

Hi Dafnis,

I believe it is possible, a pivot Table object might do the trick.

[dafnis14]

Hi,

I attached a simplified data model.

Thanks!

[jpenuliar · Accepted solution]

Hi Dafni,

have a look at attached file using pivot, not exactly as your attached image but nearly there. I only done a define year selection, you can make the current year/previous year dynamic or based on selection.

Have a look at sample / demo files to get an idea how you be able to present Comparison in different ways.

[dafnis14]

That's very cool!

Thanks!

I could never think about such a solution..

[dafnis14]

Hi Jonathan,

I would appreciate if you could advise regarding a dynamic year option.

For example, if a year is selected, the previous year dates are calculated like that:

Only({<year ={"$(=max(year)-1)"}>}HolidayDate)

I have updated the Sales expression as follows:

Sum({<year ={"$(=max(year)-1)"}>Sales)

but no values are shown...

Can you help me to figure why?

Thanks!