Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have production data summarized in the below format.
Product Code/Location/Quantity and Production Start and End timestamps:
I have a separate Calendar table which has all the Calendar Dates and Hours.
How can I turn the data table efficiently into a format where the quantities are evenly allocated between the start_time and end_times, so that I can visualise them on an hourly chart?
Many thanks.
needs more details. Do you need this by hour? Are there any hours that need to be excluded? Weekends? holidays?
Hi, as in the original post, I have a separate Calendar table which has all the Calendar Dates and Hours. My intention is to use that on the x-axis of the output graph.
Thanks
What about the exclusions?
User | Count |
---|---|
50 | |
39 | |
18 | |
14 | |
13 |
User | Count |
---|---|
99 | |
71 | |
29 | |
18 | |
13 |