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? -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/9836eff0-504a-4e54-b6c1-7826b9e99f8an%40googlegroups.com.
