Abstract
Our help ticketing solution would not be complete without a Power BI solution to monitor our tickets. Our SharePoint list is an easy-to-use data source. Figure 106 shows the results a couple of weeks after going live with this solution.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
This was in the summer when many of the faculty were away. The system still logged about 100 tickets per week.
- 2.
We need this extra logic because Resolved Date is just a date value without a time. This ends up being the same as 00:00 (midnight). So if a ticket is opened and closed the same day, the Days Open ends up being negative. That doesn’t make sense, so we use 0 instead.
- 3.
The Description and Notes columns have XML format. However, the approach to replace null values with <div></div> and then Parse – XML did not pay as many dividends here. This may have been due to using the RichText controls as in Figure 104.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jeffrey M. Rhodes
About this chapter
Cite this chapter
Rhodes, J.M. (2019). Using Power BI for the Help Ticketing System. In: Creating Business Applications with Office 365. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5331-1_17
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5331-1_17
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5330-4
Online ISBN: 978-1-4842-5331-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)