Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please assist with the syntax to calculate the following scenario:
Attached is a sample table of the data I'm referring to
The result will hopefully be a table/chart showing me how long it takes the sales rep to go from "open" to "won" (or any of the other states).
Hope the info is clear.
cherio
Hi Manus
for each record
LOAD
OpportunityName,
Max(SnapShotDate) - Min(SnapShotDate) should give the ellapsed time between the first (Open) and last (status) date
RESIDENT Table
group by OpportunityName;
best regards
Chris
Hi Christian, tx for the help.
NO, unfortunately I'm still lost. First off I could not get the Load script right, it gave me a load error. So I simply used the "max" - "min" in an expression and it did give me a value but this seem to be the total max and minus the total minimum, one answer is like 323 days. In my sample upload spreadsheet you'll see a status can be "OPEN" for a few dates (weeks) and then "WON" after 4 dates (weeks) and that record stays with the status of WON in the database for all the weeks after that. So the "max" calculation takes the very last record when it should have taken the 4th week date and calculated it there. Hope this makes sense