Date and Time grouping from CSV

21 views
Skip to first unread message

Leighton James

unread,
Jun 22, 2022, 3:31:28 AMJun 22
to Google Visualization API
Hi all

Using Google charts to create a dashboard for work, we generate monthly exports of the tickets we receive and these are stored in csv format.

Opening the csv file is not an issue and I am able to do the same for another page I am working on. These CSV files that we generate look similar to this:

PROBLEM_NUMBER,CALLER_NAME,PRIORITY,CALL_TIME,CALL_DETAILS,RESOLVER,RESTORING_GROUP,RESOLVING_GROUP,RESTORATION_TIME,RAG_STATUS,CALL_STATUS,CALL_TYPE,RESTORATION_CODE,SUBMITTER_GROUP,ASSIGNEE_GROUP,ASSIGNEE_NAME,RESOLVED_DATE_TIME,RESTORED_DATE_TIME,TIME_WITH_GROUP,MONTH/YEAR
P00001,Christy Mckee,4,01/01/2021 08:24,Fault 1,Jose James,Tech Group,Tech Group,01/01/2021 08:24,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,01/01/2021 08:24,01/01/2021 08:24,0,Jan-21
P00002,Melody Ruiz,4,01/01/2021 08:40,Fault 2,Tammy Mitchell,Tech Group,Tech Group,01/01/2021 08:40,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,01/01/2021 08:40,01/01/2021 08:40,0,Jan-21
P00003,Thomas Garcia,4,02/01/2021 10:56,Fault 3,Emily Leach,Tech Group,Tech Group,02/01/2021 10:56,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,02/01/2021 10:56,02/01/2021 10:56,0,Jan-21
P00004,Daniel Morales,4,03/01/2021 11:26,Fault 4,William Holmes,Tech Group,Tech Group,03/01/2021 11:26,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,03/01/2021 11:26,03/01/2021 11:26,0,Jan-21
P00005,Melissa Rodriguez,3,03/01/2021 12:36,Fault 5,Robert Riley,Tech Group,Tech Group,03/01/2021 12:36,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,03/01/2021 12:36,03/01/2021 12:36,0,Jan-21
P00006,Jennifer Murphy,4,03/01/2021 12:44,Fault 6,Robert Gonzales,Tech Group,Tech Group,03/01/2021 12:44,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,03/01/2021 12:44,03/01/2021 12:44,0,Jan-21
P00007,Beth Wright,4,05/01/2021 13:09,Fault 7,Alexandra Conrad,Tech Group,Tech Group,05/01/2021 13:09,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,05/01/2021 13:09,05/01/2021 13:09,0,Jan-21
P00008,Ryan Ingram,4,10/01/2021 13:14,Fault 8,Michael Hernandez,Tech Group,Tech Group,10/01/2021 13:14,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,10/01/2021 13:14,10/01/2021 13:14,0,Jan-21
P00009,Jimmy Hancock DDS,4,11/01/2021 13:19,Fault 9,Valerie King,Tech Group,Tech Group,11/01/2021 13:19,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,11/01/2021 13:19,11/01/2021 13:19,0,Jan-21
P00010,Kenneth White,4,11/01/2021 13:31,Fault 10,Jeff Swanson,Tech Group,Tech Group,11/01/2021 13:31,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,11/01/2021 13:31,11/01/2021 13:31,0,Jan-21
P00011,Andrea Cook,4,15/01/2021 13:33,Fault 11,Carol Pratt,Tech Group,Tech Group,15/01/2021 13:33,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,15/01/2021 13:33,15/01/2021 13:33,0,Jan-21
P00012,Matthew Gregory,4,15/01/2021 13:50,Fault 12,Suzanne Weiss,Tech Group,Tech Group,15/01/2021 13:50,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,15/01/2021 13:50,15/01/2021 13:50,0,Jan-21
P00013,Steven Estes,4,15/01/2021 14:27,Fault 13,Dustin Hernandez,Tech Group,Tech Group,15/01/2021 14:27,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,15/01/2021 14:27,15/01/2021 14:27,0,Jan-21
P00014,Robin Ortiz,4,18/01/2021 14:47,Fault 14,Heather Mccormick,Tech Group,Tech Group,18/01/2021 14:47,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,18/01/2021 14:47,18/01/2021 14:47,0,Jan-21
P00015,James Padilla,4,18/01/2021 15:10,Fault 15,Anna Lopez,Tech Group,Tech Group,18/01/2021 15:10,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,18/01/2021 15:10,18/01/2021 15:10,0,Jan-21
P00016,Lorraine Hunter,3,20/01/2021 15:50,Fault 16,Jennifer Allen,Tech Group,Tech Group,20/01/2021 15:50,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,20/01/2021 15:50,20/01/2021 15:50,0,Jan-21
P00017,George Terry,3,20/01/2021 16:01,Fault 17,Karen Gutierrez,Tech Group,Tech Group,20/01/2021 16:01,AMBER,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,20/01/2021 16:01,20/01/2021 16:01,4417,Jan-21
P00018,Larry Valdez,4,21/01/2021 16:06,Fault 18,Candace Arnold,Tech Group,Tech Group,21/01/2021 16:06,RED,Closed,Problem,Fixed,Reporting Centre,Reporting Centre,,21/01/2021 16:06,21/01/2021 16:06,0,Jan-21

(Would have attached the csv but work web browsing policies prevent me from doing so)

I need to be able to generate a chart that displays the ticket count per day but I can't figure out how to do this from the data in the csv.

Can anyone advise me please?


Reply all
Reply to author
Forward
0 new messages