This is my table. Column A is the date and Time. Column B, '1' is success job and '0' is failure job. I was wondering how can i display the the success/failure job over 24 hours? So i can see among which period does the failure job occurs the most. However, I realized if I put time as the dimension, it would be very crowded. Is there any type of charts that can display the data in a better way?
I have also attached the sample excel file for your reference.