Set Analysis Track Conversion Over time

[aaronnayan]

Hi Guys,

I'm hoping you can help me with the best way to approach this.

If I have at the start of the month £100,000 of Apples orders at the start of the month. I want to calculate the conversion rate of how many orders were finalised at the end of the month.

100 [Open] Orders @ start of month 

50 [Closed] Orders @ end of month 

Conversion Rate should be 50% - How would i calculate this?

However the orders status field for every order "Open", "Closed" can change over time depending on Sales Orders. How would i capture the status of the order at a certain time?

Key Fields -

[Order Status]

[Order Create Date]

[Order Close Date]

[dplr-rn]

it can but how depends on what you want to achive.

you may need to save your data into a qvd on a daily basis.
read current data - check against saved qvd for changes in some way etc.

overall my first question would be what business benefit is there by capturing the change