I would like to add a column in a Milestone Collector that calculates the duration between the Start and Finish times, which are in separate columns. Please let me know what I should try to use in the Value field. Thanks in advance for your help.
Hi John,
If you can live with the duration column in a different table, you could use a Calculated Table to subtract the two columns. That has the advantage of using SQL to aggregate/filter/group etc.
Another option would be to use a second statistics collector to listen to the first collector. You can set it up so that when the milestone collector writes the second milestone time, you can calculate the difference between the first and second milestone times, and record that in a table. That has the advantage of having a table built incrementally, instead of all at once like a calculated table. If I had to guess, I'd say that this is the option for you, even though it will create a second table.
If you want the same table to have both time stamps and durations, then you'll need to create your own statistics collector. A milestone collector is a statistics collector with a strict/specific UI. There is no functional difference between the two.
Thanks @jordan.johnson. I used calculated tables for this and got what I needed. Being able to directly write the SQL code helps.
Hi, I'm having trouble creating a calculated table / statistics collector that listens to my milestones. Any help??
Thanks
Please post a new question explaining your problem with an attached model.
14 People are following this question.
