Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TM1992
Frequent Visitor

Time intelligence visualisations

Hi everyone,

 

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 im trying to develop these metrics/Visualisations:
  1. 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 

       2. Average time spent from office write up to Journal.

 

       3. March 2020 Vs June 2021 - Average times spent in office write up to journal.

 

       4. Total Tests by period - Show all tests conducted in March 2020 and June 2021

 

    Unfortanetly i am having issues with the data set, maybe its due to the way its set up? or im 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 

 

    Kind regards,

    Thomas

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @TM1992 ,

When I click the link you shared ,see the below:

vluwangmsft_0-1626402019325.png

 

 

Best Regards

Lucien

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.