How do you visualize a log table to identify record changes ?

Hi guys,

Need some advice when we have a table contain data log history, and we want to visualize from time to time what are the changes being made (and maybe by who), what is the best way to visualize it ?

I don’t have any data yet, but I think like a common log table contain several field in our original table, let say if it is Sales Orders table, the log table may contain field such as item id, prices, qty, delivery date, status, modify (entry) by. So time to time in one sales order the value of the fields may change. And in each changes, this table log will record this, so there will be as much line (row) as the data changed. I would like to build a report that visualize this.

Probably the purpose (for start) is to find which field changed very often or whose the person that keep changing data.

Appreciate for any idea.

Thanks