This is my first post on the forum and it would be great if i could get your help.
I am working on a Time Data Analysis. I retrieved data from an application used to conduct driving tests and I’m trying to develop these metrics/Visualisations:
Total time spent from office write up to Journal:
Point A = Pass/Fail/Test Summary Screen - These are the office write up categories
Point B = Journal Event immediately after - This is the journal category
Average time spent from office write up to Journal.
March 2020 Vs June 2021 - Average times spent in office write up to journal.
Total Tests by period - Show all tests conducted in March 2020 and June 2021
Unfortunately I am having issues with the data set, maybe its due to the way its set up? Or I’m possibly calculating the wrong measures.
I’ve attached the file for your reference, again if anyone could help that would be much appreciated. https://1drv.ms/u/s!AoTkCNSjWHozjh42H3wR-hi56pRY