Help required in timeline pivot table!

[#1]

Hi

I want to pass Week/Year/FinancialYear/etc... instead of Date in the attached pivot table. I tried to create a group by adding Week(Date), Year(Date),etc in that group and passed the created group instead of Date but it didn't work.

Can anyone helpme out on this please.

[#2]

Hi ,

Can you please post some sample data how it should look like.

[#3]

Hi

As I said instead of Date in the pivot table it should be week. Hope it is understandable now!

[#4]

Hello,

Try to calculate Week(date), Year(date) in the script when reloading data.

regards,

Beyrem

[#5]

Beyrem wrote:
Try to calculate Week(date), Year(date) in the script when reloading data.

Thanks!

I have already tried that but it is not working.

[neetu_singh]

Hi,

At scripting level, please specify same date format in all dates as -

DATE (

(StartDate+IterNo()-1),'DD/MM/YYYY') AS date

use this format in all rest date field and then derive week(date) as week, year(date) as year.

It will work.

Regards

Neetu Singh

[#7 · Accepted solution]

It's not working, because of your expression. When you switch to weeks, years, etc. anything that includes more that one dates, will result in multiple records within one set of dimension values and therefore you need an aggregation function in order to accommodate these multiple records so that you end up with 1 value. In this case a simple SUM around your expression will do it. Check the attached file.

[#8]

Hi Iassen

Your trick has worked yet again! Many thanks to you...

[#9]

Glad to hear it! Enjoy! 🙂

Thanx for the points! 🙂

[#10]

Hi Iassen

In the sample application which you have provided the solution above. If I add MonthName(date) in the group chart are displayed as shown in the figure. I don't want that to display the something like "##'. I think that is because of less to display the data. Could you please tell me how that could be resolved. I am sorry if it is very simple. But please do let me know how to solve that issue. Please do it only when you are free.

Please make sure that it should not display "##" any more for what ever the time line pass in the group.