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:
- Using Archibus Smart Client, I exported the work request(wr) table data into an excel spreadsheet,
- Imported the data into Power BI,
- Applied a date filter to view data from the last 2 years,
- 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
