How to count how many times a field has been edited?

[Itay Goldshtein]

Hi everybody,

I want to create a Single Score report, that counts the average number of times that the field "Assigned to" has edited per call (incident) . Not including the first time and not including the times that make the field empty. I mean, I want to count how many times there was a "change of hands" per call (incident). 

This is what I have done so far without success:

Can you please help me to do this?

Thanks,

Itay

[Community Alums]

Hi @Itay Goldshtein ,

If this is critical to your reporting, the easiest way to achieve this would be to add a field to the table (that's not displayed by default on forms or lists, and is read only). You can then use a flow or business rule to increment the counter during the conditions you want to count. 

Then it will be available on any dashboards and reports that you need it to. 

[Itay Goldshtein]

Thank you very much @Community Alums Sandeep Dutta. Can you explain to me how to actually do it or send a screenshot? Because I am not familiar with the things you wrote about.

[Ole Kirkegard]

Hi @Itay Goldshtein 

If it's an audited table you could consider retrieving this information from the sys_history_line table, querying e.g. a specific incident and the latest record of the field in question and look at the Update number.

Another options could be to if its on incidents to configure and use a metric, which will give you an entry for each field update in e.g. incident metrics table.

/Ole

[Ole Kirkegard]

Hi @Itay Goldshtein 

In case the table in question is audited, you may also find the update count in the table sys_history_line querying the specified record and the latest record for the field in question, which holds the update number for that field.

Another options could also be to look at Metric Definitions and if not already existing then create one for the given field and table. This will populate a entry in the metric_instance table for each change to that field. By enabling timelines in the metric you even get that bonus of being able to see the timeline visualization of the updates made to that field over the incident life-cycle.

/Ole