Hello All,
This is my first post so please be kind. I am working on a project and I am trying to figure out how to calculate the duration of each event in a power pivot table. The columns included are ResourceName, EventStartTime, and Duration. The table is of call logs and activities throughout the day for 2 years which include multiple agents. The only column that the informix database records is the eventstarttime. I am trying to add a column where i can calculate the duration by taking the sequential resourcename and eventstarttime and subtract against the previous starteventtime. The problem I am having is making sure the resourcename is subtracting against the resourcename e.i (resourcename=resourcename). Thanks for your help.
Other recent topics
