Last 5 week trends for comparing current week value vs last week value

[deepakkrish]

Hi All,

Great day for you ..

I want to calculate trends for last 5 week to comparing one value from last week vs Current week. below is my table.

I have a date field called time stamp this contains only Monday dates.

Data for 28/10/19                                                       

Timestamp	ID	stage
28th Oct 2019	1	qualified
28th Oct 2019	2	qualified
28th Oct 2019	3	qualified
28th Oct 2019	4	qualified
28th Oct 2019	5	qualified

Data for 04/11/19

Timestamp	Id	stage
4th Nov	1	propose
4th Nov	4	Propose
4th Nov	8	not
4th Nov	6	qualify
4th Nov	7	not

Now I have to compare how many stages moved qualified stage to proposed stage, So comparing last week data 28/10/19 there are 5 qualified and this week 2 changed to propsed stage ..so my result is 2/5 =0.4

This should be calculated for trends in last 5 week. 

please suggest some ideas to solve this task..

Regards,

Krish.

[Arthur_Fong]

I build this at script level:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[deepakkrish]

Hi Arthur,

Thanks for your reply , For some reason I cant try this in script side . can you help me to do this in script side .

Regards,

Krish.

[Arthur_Fong]

The qvw i shared is built in script already.

[deepakkrish]

The record count is  more and I cant run any scripts on back end now .. Expecting this should be done on chart side , rather case i have to go with excel sheet.. so I am trying to get this to be in front end.

Regards,

Krish.

[simrankaur]

Please find the ans in the qvw attached.

[deepakkrish]

Thanks for your reply .. Do you have any idea to implement this in chart using set analysis or any condition?

[simrankaur]

I worked on it and it cannot be done completely on UI because you cannot call two different dates on the same row but you will have to make a little adjustment in script to make it work on UI.

This has the minimal backend work which has to be done to solve your problem.