Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I build this at script level:
Refer qvw attached as reference.
Thanks and regards,
Arthur Fong
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.
The qvw i shared is built in script already.
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.
Please find the ans in the qvw attached.
Thanks for your reply .. Do you have any idea to implement this in chart using set analysis or any condition?
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.