I am needing to build a dashboard to represent TAT on Account Implementations for various teams. I am being asked to use a field history report that will give me a date and time stamp when Stage or the Platform Setup field is changed. We want to be able to show an overall TAT but granular time spent in the various options. Historically I have had a report that would be a single line item per Opportunity with the date stamps out the right in columns.
Is there a way in airtable, or before airtable, to help me consolidate or accurately report the metrics?
Here is a snapshot of the data from the field history report I am being asked to use:
