Make chart

Copper Contributor
I need to know duration (How many days) between send email and receive email for each employee and what data I need to make this chat
3 Replies

@Esraa1992 

Duration is just by subtracting send datetime from receive datetime. But which kind of chart you'd like to have? You have at least few employees, many emails for each, Is that distribution of response time by dates, or min/max, or average or what?

min/max, and average (How many days each employee are taking to replay)

@Esraa1992 

As variant, if you have duration of each response in one column against employees names in another column, you may build PivotTable on this range aggregating duration as min, max and average. On the top of this PivotTable you may add PivotChart for visualization of this information. Something like this

image.png