How to create a table to show age by day?

[manny88]

I would like to know of the "Open Cases", can we build something to show an age profile similar to something like "1-3 Days", "4-7 Days" "8-11 Days" etc.

For this I would like to be able to see by Group, which can be looked up in the table from the "Created By" (Column I) name. The "Created By" name in Column I may be blank if it was an "email received" from a customer rather than an "internal case", so will need to factor that in. Ideally something that will let me analyse similar to a pivot table, with a graph included as a bonus.

I have included a table template and would appreciate the help!



[TABLE="width: 2825"]
<tbody>[TR]
[TD]Email[/TD]
[TD]Customer No[/TD]
[TD] Status[/TD]
[TD]Project[/TD]
[TD]Media Type[/TD]
[TD]Visibilty[/TD]
[TD]Subject[/TD]
[TD]Description[/TD]
[TD]Created By[/TD]
[TD]Created Date[/TD]
[TD] Assigned To[/TD]
[TD] Assigned Date[/TD]
[TD] Closed By[/TD]
[TD]Closed Date[/TD]
[TD]Last Activity[/TD]
[TD] Number of Attatchements[/TD]
[TD]Number of Follow Ups[/TD]
[TD] Code[/TD]
[TD]Email Direction[/TD]
[TD]Days to Complete[/TD]
[TD]Days since Last Activity[/TD]
[TD]Department[/TD]
[/TR]
[TR]
[TD]man@imail.com[/TD]
[TD="align: right"]957801[/TD]
[TD] Closed[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]RE: Your Quote[/TD]
[TD]Text about a random quote to a customer[/TD]
[TD]Customer (John Smith)[/TD]
[TD="align: right"]10/08/16[/TD]
[TD] David Davies[/TD]
[TD="align: right"]10/08/16[/TD]
[TD] Tony Stark[/TD]
[TD="align: right"]11/08/16[/TD]
[TD="align: right"]11/08/16[/TD]
[TD="align: right"] 1[/TD]
[TD="align: right"]0[/TD]
[TD] Quote[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]80[/TD]
[TD] Back Office[/TD]
[/TR]
[TR]
[TD]theman@imail.com[/TD]
[TD="align: right"]967802[/TD]
[TD] Closed[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]System Issues[/TD]
[TD]Text about a random system issue[/TD]
[TD]Customer (Alan Roberts)[/TD]
[TD="align: right"]15/08/16[/TD]
[TD] Peter Parker[/TD]
[TD="align: right"]15/08/16[/TD]
[TD] Chris Martin[/TD]
[TD="align: right"]15/08/16[/TD]
[TD="align: right"]15/08/16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD] Billing[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]76[/TD]
[TD] SME[/TD]
[/TR]
[TR]
[TD]mantheman@imail.com[/TD]
[TD="align: right"]977803[/TD]
[TD] Open[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]System Issues[/TD]
[TD]Text about a random system issue[/TD]
[TD]AJ Mike[/TD]
[TD="align: right"]20/08/16[/TD]
[TD] Tony Stark[/TD]
[TD="align: right"]20/08/16[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10/10/16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD] Null[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]-42602[/TD]
[TD="align: right"]20[/TD]
[TD] Back Office[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]987804[/TD]
[TD] Closed[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD][/TD]
[TD]Random text about Random stuff[/TD]
[TD]Customer (Sue Highway)[/TD]
[TD="align: right"]10/09/16[/TD]
[TD] Elena Michael[/TD]
[TD="align: right"]15/09/16[/TD]
[TD]Elena Michael[/TD]
[TD="align: right"]10/10/16[/TD]
[TD="align: right"]10/10/16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD] Billing[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]20[/TD]
[TD] Sales[/TD]
[/TR]
[TR]
[TD]daman@imail.com[/TD]
[TD="align: right"]997805[/TD]
[TD] Open[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]What happened today?[/TD]
[TD]Random text about office gossip[/TD]
[TD]Steve Kelly[/TD]
[TD="align: right"]15/09/16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD] Null[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]-42628[/TD]
[TD="align: right"]42673[/TD]
[TD] Customer[/TD]
[/TR]
[TR]
[TD]zaman@imail.com[/TD]
[TD="align: right"]1007806[/TD]
[TD] Open[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]Welcome![/TD]
[TD]Text to welcome a random customer[/TD]
[TD]Automail[/TD]
[TD="align: right"]20/09/16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD] Null[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]-42633[/TD]
[TD="align: right"]42673[/TD]
[TD] Customer[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1017807[/TD]
[TD] Closed[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]FW:[/TD]
[TD]A forwarded email with no real subject[/TD]
[TD]Dev Patel[/TD]
[TD="align: right"]25/09/16[/TD]
[TD] Bruce Wayne[/TD]
[TD="align: right"]25/09/16[/TD]
[TD] John Smith[/TD]
[TD="align: right"]05/10/16[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] Sales[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]42673[/TD]
[TD] Complaints[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1027808[/TD]
[TD] Open[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]System Issues[/TD]
[TD]Text about a random system issue[/TD]
[TD][/TD]
[TD="align: right"]10/10/16[/TD]
[TD] Michael Owen[/TD]
[TD="align: right"]10/10/16[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20/10/16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD] Billing[/TD]
[TD][/TD]
[TD="align: right"]-42653[/TD]
[TD="align: right"]10[/TD]
[TD] Front Office[/TD]
[/TR]
[TR]
[TD]Michael Drewsbury[/TD]
[TD="align: right"]1037809[/TD]
[TD] Closed[/TD]
[TD]Default[/TD]
[TD]Email[/TD]
[TD]Internal[/TD]
[TD]Copy of Sales[/TD]
[TD]Text with a file included on forecasted sales[/TD]
[TD]Helly Hansen[/TD]
[TD="align: right"]15/10/16[/TD]
[TD] Kelly Smith[/TD]
[TD="align: right"]15/10/16[/TD]
[TD] John Smith[/TD]
[TD="align: right"]25/10/16[/TD]
[TD="align: right"]25/10/16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD] Sales[/TD]
[TD]Outbound Mail to Customer[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD] Front Office[/TD]
[/TR]
</tbody>[/TABLE]