Adding fields to Metric Instance Table

[DavidChazin]

Hi All.

Is it safe to add a field to the Metric Instance table?

I created a field in the Incident table that is a concatenation of the Assignment Group name and the State of an Incident ticket.   Then I created a new Metric Definition against that field.   So, now, I have Metric Instance records that measure the elapsed time an Assignment Group was assigned to a ticket, while the ticket was in any particular State (e.g., New, Active, etc.).

I need an additional Metric Instance field to keep track of what the Priority of the ticket was, when the End field was populated in the Metric Instance record.

Thanks for your help.

—David Chazin

[faisal_dadabhoy]

I don't believe technically this is an issue. I have also tested it works fine.

However, I personally don't like the idea of altering the metric_instance table.

The other option would be to create a new table for reporting and populate with a async business rule.

Hope it helps.

Thanks, Faisal Dadabhoy