Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data like:
I want to calculate 3 things:
1.The first time the vip bought Item B.
2.The first time the vip purchased.
3.The QTY of B in the first time that the vip bought Item B.
I have done the 1 and 2, but for the 3, I wrote some expressions which only works when I choose one vip, If I didn't choose any vip, the expression didn't work, and I don't know why. You can see them in attached file.
What I want the result is:
Actually without column 2 and 3 is ok for me, and you also can create a new report and add some calculation dimension to make it.
Because I used these three expressions below, they all didn't work:
=Aggr(SUM({<TIME={"$(=DATE(min({<ITEM={"B"}>}TIME),'YYYY-MM-DD'))"},ITEM={"B"}>}QTY),VIP)
=SUM({<TIME={"$(=Aggr(DATE(min({<ITEM={"B"}>}TIME),'YYYY-MM-DD'),VIP))"},ITEM={"B"}>}QTY)
=Aggr(SUM({<TIME={"$(=Aggr(DATE(min({<ITEM={"B"}>}TIME),'YYYY-MM-DD'),VIP))"},ITEM={"B"}>}QTY),VIP)
I don't want to modify the script in backend, I just want to make it using dimension or expression and of course you can create a new report to calculate this without 1 and 2.
Please feel free to contact me if you have any questions, and if you have any idea please tell me, thank you so much!
That's cool!, Thank you so much.