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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kschulte
Frequent Visitor

Weekly Timecard Submittal by Time and Date

I need to be able to visualize what date and time our timecards are submitted each week. Any ideas?

1 ACCEPTED SOLUTION

hi @kschulte - I have uploaded the pbix file to the below folder; let me know if you get to it. 

https://drive.google.com/drive/folders/1PTSfNYyvW4erinQBGDOyLmeQ00jI_1Zc?usp=sharing

 

I also imported and created a couple of visuals with the data you had provided. 

Sumanth_23_2-1601015331650.png

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

9 REPLIES 9
Sumanth_23
Memorable Member
Memorable Member

hi @kschulte - you could probably plot the days of the week by hours and counts of submissions on a bar or line graph to understand this information. 

I dont know your exact data scenario but something like the below could show you a trend on the days and times of submission of time cards

Sumanth_23_0-1600969659015.png

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



I like what I see there, Sumanth_23. Can you please provide the pbix file?

hi @kschulte - I have uploaded the pbix file to the below folder; let me know if you get to it. 

https://drive.google.com/drive/folders/1PTSfNYyvW4erinQBGDOyLmeQ00jI_1Zc?usp=sharing

 

I also imported and created a couple of visuals with the data you had provided. 

Sumanth_23_2-1601015331650.png

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Can you share a pbix file that shows this?

if you provide data in a text format, i can create one.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Data, in a txt format (I don't see where to attach a file).

 

Person ID Network Username User Full Name Timecard Week Begin Date Submitted Date
14785 ALGORDON Gordon, Alex L 10/6/2019 10/7/2019 4:48:30 PM
641 KHIMES Himes , Kimberly E 10/13/2019 10/9/2019 1:59:53 PM
10393 KNPATRICK Patrick , Krystal N 10/4/2019 10/9/2019 2:00:34 PM
14020 DFENDELANDER Fendelander , David D 10/6/2019 10/9/2019 2:02:19 PM
8510 BJMILLER Miller , Brody J 10/6/2019 10/9/2019 2:07:50 PM
11421 DADEAN Dean , David A 10/6/2019 10/9/2019 2:08:26 PM
3390 JRONCO Ronco , Joshua M 10/6/2019 10/9/2019 2:11:15 PM
1614 MDREW Drew , Michael D 10/6/2019 10/9/2019 2:29:50 PM
9118 DLCLARKE Clarke , Dennis L 10/6/2019 10/9/2019 2:54:07 PM
3881 GBRENNAN Brennan , George M 10/6/2019 10/9/2019 2:55:36 PM

 

 

vanessafvg
Super User
Super User

what do you want to do with that information? what else do you want to see with that, who is our timecards and what is their relevance. Can you please elaborate this isn't much to go on.




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




timecards in my organization are submitted weekly. We define a week as starting on Sunday and ending Saturday. I would like to show (perhaps on a heat map) when (day and time) each timecard was submitted for the previous week. i have the data from our timekeeping system.

 

Person IDNetwork UsernameUser Full NameTimecard Week Begin DateSubmitted Date
14785ALGORDONGordon, Alex L10/6/201910/7/2019 4:48:30 PM

i would split my date and time and create date and time dimensions that drill down in to time of day, pm vs am, day of week, etc. and then do a day of the week with a time of day analysis.

You could probably use a tree map with conditional formatting to show the days or times. there are also some custom visuals that show calendar information, or even just a bar chart to show times of day, sorted in order of no of submissions.

Also if you have more information about the type of staff that are submitting like roles and such that too adds more context.




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.