Season's Savings | ₹5/mo for 3 months

₹199/month after first 3 months. Renews automatically. Terms apply.
How to Build an Annual Process Year Wheel in SharePoint with Copilot cover art

How to Build an Annual Process Year Wheel in SharePoint with Copilot

How to Build an Annual Process Year Wheel in SharePoint with Copilot

Listen for free

View show details
About this listen

Yes. An annual processes list in SharePoint can show the whole year as an interactive year wheel, built with Copilot in SharePoint and D3.js from five prompts.

An annual processes list tells you when things happen, but readers still have to piece the year together. In this Tech Ease episode, I walk through a SharePoint year wheel: months around the center, one colored ring per department, and every process drawn as a curved bar across the months it runs. Department filters, month selection, a process-count chart and a Back to today button help people explore what applies to them. The sample uses 30 made-up processes for a fictional company, across seven departments. The skill package is ready to download.

Chapters

0:00 Could your list show the whole year?

0:27 Where the idea came from

0:41 The year wheel I built

1:06 Select, hover, filter and rotate

1:44 Who connects the dates?

2:06 The five prompts

2:22 Prompt 1: Create the list

2:43 Prompt 2: Fill it with sample data

3:05 Prompt 3: Build the D3 year wheel

3:48 Prompt 4: Add animation and interaction

4:35 Prompt 5: Add the manager summary

5:00 Live from the SharePoint list

5:09 When a wheel is the right view

5:30 Try it yourself

The five prompts, in order (full text is in the pinned comment on the YouTube video):

1. Create the list

2. Fill it with sample data

3. Build the D3 year wheel

4. Add animation and interaction

5. Add the manager summary

Run them one at a time and check each result before the next.

Tips

Keep Start Month and End Month as number columns. The wheel is only as clear as the start month, end month and department in your list. Check after each prompt, and ask Copilot to remove any extra ring or glow you did not ask for.

Try the live year wheel: https://anandragav.github.io/copilot-html-dashboards/annual-processes-year-wheel/

Download the skill package (.zip): https://github.com/anandragav/copilot-html-dashboards/releases/download/annual-processes-year-wheel-v1/annual-processes-year-wheel-skill.zip

More sample dashboards: https://anandragav.github.io/copilot-html-dashboards/

Watch on YouTube: https://youtu.be/VRtjFYBzsl4

Tech Ease on YouTube: https://www.youtube.com/@anandvijayaragavan18

Follow Tech Ease on Spotify: https://open.spotify.com/show/0Cd8NsDE7kdQmLnbXe8Xx1

adbl_web_anon_alc_button_suppression_t1
No reviews yet