cmcarthur

Hi Rich, I was surprised how many requests were submitted by our own department! To create the bar visual from a spreadsheet view, I did the following:

1. Using Archibus Smart Client, I exported the work request(wr) table data into an excel spreadsheet,
2. Imported the data into Power BI,
3. Applied a date filter to view data from the last 2 years,
4. Selected the spreadsheet visual and selected the Requested by and Count of Work request code, then selected the bar chart visual.

Here’s a 35 second video that illustrates the last few steps in the process. https://ocas.sharepoint.com/:v:/r/sites/co-ocappa/Shared%20Documents/Resources/Recordings/35%20seconds%20of%20Power%20BI.mp4?csf=1&web=1&e=mfG9cW&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbE1vZGUiOiJtaXMiLCJyZWZlcnJhbFZpZXciOiJwb3N0cm9sbC1jb3B5bGluayIsInJlZmVycmFsUGxheWJhY2tTZXNzaW9uSWQiOiI4MjlmYmYyZC1mZjhjLTRmYTMtOTIwYy00M2FmZDczOWJkOGUifX0%3D

• This reply was modified 1 day, 5 hours ago by cmcarthur.
• This reply was modified 1 day, 5 hours ago by cmcarthur.

Hi Karen,

thank you very much for the detailed information.  I will share this info with my colleagues.

thank you Mona, I will check out these suggestions.

Colleen McArthur, Algonquin and Suzanne Hardcastle, Humber

thats great to hear!  I love this tool, and the Scheduling Poll is really useful.  thanks