Capturing open orders that occured in a certain period in time

[Anthony stark]

Hi Guys,

I have a requirement where they client needs to see the orders that where open in a certain point in time. For example, an order that was open in july would not be open in september, but how do i show that order, and total orders that where open in july (or any other previous month before they were closed) Currently we just calculate the total open orders at the end of each month and input it in excel manually month-by-month and build a line chart of the trend. IS there a way to do this with spotfire

Thanks in advance

[Kirsten Smith (she/her)]

Seems you could use a case() statement to identify the open orders, depending on how your data is organized. Something like:

 

case when [Open date] > [start Date] AND [Open Date] < [End Date] then "True" else "False" end

[Anthony stark]

Hi Kristen,

 

There is no open , close , or start date for the Orders. when they are closed they are not in the system anymore. We are trying to track how many are open when hey are open by month

[Kirsten Smith (she/her)]

Spotfire needs something to look at to determine when an order was opened, and it has to be in the system to do any kind of aggregation.