Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Date, Membership signup date ,Customers and orders, I want the output where each customer before signup how many orders or after signup how much orders they are placed.
Each customer have their each signupdate.
For example-
Cust | Date | SignUp date | orders |
1 | 2017-12-30 | 2017-10-30 | 0.49145 |
1 | 2017-12-12 | 2017-10-30 | 0.98633 |
1 | 2017-11-19 | 2017-10-30 | 0.32968 |
1 | 2017-11-16 | 2017-10-30 | 0.24649 |
1 | 2017-11-06 | 2017-10-30 | 0.19674 |
1 | 2017-11-06 | 2017-10-30 | 0.19695 |
1 | 2017-11-06 | 2017-10-30 | 0.19768 |
1 | 2017-11-06 | 2017-10-30 | 0.19798 |
1 | 2017-10-30 | 2017-10-30 | 0.33333 |
1 | 2017-10-07 | 2017-10-30 | 0.5 |
1 | 2017-03-25 | 2017-10-30 | 1 |
1 | 2017-02-23 | 2017-10-30 | 0 |
I want output sum(orders) before signup date 2017-10-30 and after signupdate, I have so many customers and having different signup date.
Thanks for help!
Thanks for the explanation !! As i said before learning new things everyday.
Hi,
This is the only problem I am facing, It takes min and max date of all customers and evaluate. But every customer have their own signupdate
Please help me on this.
Thanks
Hi Paridhi
As Sunny explained Set analysis is evaluated once per the chart so you have to turn to other thing for example here scripting if you want row wise implementation like this .
Please change the script. it will definitely work for you.
regards
Pradosh
Hi,
What I need to change in my script?
Thanks in advance
I showed you what can be changed... don't like any of the ideas?