Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
Can you post sample data
Hi,
I just did..
Thanks!
the attachment is basically the report you want to achieve,
Do you have source data, table/s where the report takes data from?
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!
Hi Dafnis,
I believe it is possible, a pivot Table object might do the trick.
Hi,
I attached a simplified data model.
Thanks!
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.
That's very cool!
Thanks!
I could never think about such a solution..
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!