Report on Task Duration by RITM item and Assignment Group

[daniellethomson]

This doesn't seem like it should be that difficult but I can't get it to work. I have a SC Task duration metric but reporting wise I can't filter it down to assignment group and item. So I tried the sc task table directly and there is no OoB calculation ran at the task level for business duration. I was hoping I didn't have to 're-invent the wheel' here but I don't see how to get be the reporting I need without creating a mark closed business rule for duration at the task level. Does this seem like the most likely option? Am I missing an easier way to get a report that breaks down the task duration by assignment group and RITM?

Thanks for any help in advance!

[Michael Fry1]

If you're using a Field value duration, it's really just creates flat records that you can't drill into. Most metrics do.

Check out the out of the box Metric named: Create to Resolve Duration - I'd create this one as it uses a script and you can control the data you want to see.

[Josh Cooper]

Another option is to build a database view, where you link sc_req_item, sc_task, and metric_instance table.   So first table would be sc_req_item (with prefix of req), second table would be sc_task (prefix of task) with the where condition (task_req_item = req_sys_id) then metric instance (prefix mi) where mi_value = sc_req_item (or sc_task, whatever the metric instance refers back to) So if your current indicator to get duration is pointed to the Metric Instance table (most likely) you can repoint Indicator Source to that Database view.       Then filter your indicator for "Definition is " <the name of your duration metric>.

When you build the Indicator source, you can choose which table you want the records to drill into, so if you select sc_req_item or sc_task, you can use the metric in your indicator and filter, then show the task or sc_req_item records in the drilldown.