Home

Make chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1004396%22%20slang%3D%22en-US%22%3EMake%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1004396%22%20slang%3D%22en-US%22%3EI%20need%20to%20know%20duration%20(How%20many%20days)%20between%20send%20email%20and%20receive%20email%20for%20each%20employee%20and%20what%20data%20I%20need%20to%20make%20this%20chat%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1004396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1004557%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1004557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F456219%22%20target%3D%22_blank%22%3E%40Esraa1992%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDuration%20is%20just%20by%20subtracting%20send%20datetime%20from%20receive%20datetime.%20But%20which%20kind%20of%20chart%20you'd%20like%20to%20have%3F%20You%20have%20at%20least%20few%20employees%2C%20many%20emails%20for%20each%2C%20Is%20that%20distribution%20of%20response%20time%20by%20dates%2C%20or%20min%2Fmax%2C%20or%20average%20or%20what%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007447%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007447%22%20slang%3D%22en-US%22%3Emin%2Fmax%2C%20and%20average%20(How%20many%20days%20each%20employee%20are%20taking%20to%20replay)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1008077%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F456219%22%20target%3D%22_blank%22%3E%40Esraa1992%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%2C%20if%20you%20have%20duration%20of%20each%20response%20in%20one%20column%20against%20employees%20names%20in%20another%20column%2C%20you%20may%20build%20PivotTable%20on%20this%20range%20aggregating%20duration%20as%20min%2C%20max%20and%20average.%20On%20the%20top%20of%20this%20PivotTable%20you%20may%20add%20PivotChart%20for%20visualization%20of%20this%20information.%20Something%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20535px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157153iB98D0564F6FB2833%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Esraa1992
New 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

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies