
Case #
Case Description
Open Date
Close Date
Case Category
Case Priority
User
Case Status
Agent
Agent Group
- ...add your own attributes!
Required Attributes
To get your Service Desk dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):
- Case # Case Unique Identifier
- Case Description Description of the Case
- Open Date Case Open Date-Time (Date used for time-series analysis)
- Close Date Case Close Date-Time (if applicable)
- Case Category Case Category
- Case Priority Case Priority (expected values: 'High', 'Medium', 'Low')
- User Who raised the case
- Case Status Case Status (expected values: 'Open', 'Closed', 'On-hold')
- Agent Agent working on the case
- Agent Group Group of the Agent
KPIs
Your Service Desk dashboard will contain 10 KPIs
- Open CasesNumber of Open Cases
- Open Cases Duration Time (min)Number of minutes since the opening of Open Cases (Total is computed using Median)
- High Priority Open CasesNumber of High priority Open Cases
- Closed CasesNumber of Closed Cases
- Resolution Duration (min)Resolution duration for Closed Cases (Total is computed using Median)
- Closed Cases per AgentNumber of Closed cases per Agent
- Created CasesNumber of Cases created over the period
- Created Cases per UserNumber of Cases created per User
- UsersNumber of Users
- AgentsNumber of Agents
Dashboard Pages & Data Visualizations
Your Service Desk dashboard will contain 9 pages
Cockpit
Service-Desk Analytics
Performance of Agent Groups
Resolution Duration by Category
Creating your SERVICE DESK dashboard Step-by-Step
You want to get a clear understanding on your Service Desk results? You want to build a Tableau dashboard to better understand your Service Desk data?
Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Service Desk data in less than 5 minutes!
1st STEP: Create the initial Tableau workbook file
Create a Tableau workbook in which you map your Service Desk data (whether it comes from: ERP, database, Excel, CSV file...)
You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):
2nd STEP: Upload your Tableau workbook file
On LinPack-for-Tableau.com, select 'create dashboard from template: Service Desk' and upload your Tableau workbook (note: your data is NOT uploaded).
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Service Desk dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Service Desk dashboard is now ready to be used or customized!