How to create report on incident table whenever priority changes from one to another?

[vardhan3]

How to create report on incident table whenever priority changes from one to another?

For example i have created today one incident on Priority high then later on Changed to Medium

here need data from how many priority Changes(past /Future).

If u know the Answer, pls respond.

[palanikumar]

sys_history_line is the table name. You can type sys_history_line.list from the navigation menu filter to view this table

[Shruti]

Navigate to Metrics -> Definitions

Create new definition

For reporting, create a report on metric_instance table filter by metric definition and group by ID

[vardhan3]

Hi Shruti,

Thanks for reply, I need past Data, Metrics will give future data only right?