Weekly Timecard Submittal by Time and Date

[kschulte]

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

[Sumanth_23]

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

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

[kschulte]

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

[Sumanth_23 · 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. 

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

[kschulte]

Can you share a pbix file that shows this?

[vanessafvg]

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

[kschulte]

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]

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.

[kschulte]

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 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

[vanessafvg]

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.