Creating a Pie Chart Widget

This article shows how to create a pie chart widget that shows the total number of tickets per issue type in the last 7 days. It applies to MSPbots users with an Autotask integration.

1. Navigate to Widgets on the MSPbots app menu.
2. Click the New Widget button and select the Pie Chart widget type.
3. When the Widget Builder window appears, provide the following:
   Name - Give the widget a name.
   Description - Give the widget a short description.
   Role - Select Admin and User.
4. Click the Apply button.
5. Go to Dataset and click the button.
6. Click New Layer on the Add New Layer window that appears Autotask / Autotask Ticket Statistics as Dataset name. 
7. Type Count Ticket Numer | Autotask Ticket Statistics as Datasource name.
8. Under Columns Display, select the following as column names:
   company_name 
   ticket_number
   issue_type
   sub_issue_type
   create_date
   completed_date
   Click the button to add more rows.
   
   
9. Give each entry an Alias. 
10. Indicate the following Business Types for each of the columns:
    Company - Select Text.
    Ticket Number - Select Hyperlinks. Click the paintbrush button and select Autotask Ticket URL as Format. Click Save. 
    Issue Type and Sub-issue Type - Select Text.
    Create Date and Completed date - Select Date Time. Click the paintbrush button and select YYYY-MM-DD hh:mm:ss AM/PM as Format. Click Save.
    
    
11. Under Filter, click the button > +Add Condition. 
12. Select create_date > in. For the Value field, select Previous > 1 > Weeks (Mon-Sun).
13. For measure, click the button. Select Count for Summary Type and Ticket Number for Field. Select Number for Format Type and select Regular (1,000) as Format. Click Add and Save. 
14. Click the Config button on the left pane.
15. Select Issue_type for the X-Axis and Ticket Count as Y-Axis. 
16. Select Ticket Count for the Measure Text field. 
17. Give the Pie Chart Title. 
18. Click Apply. 
19. To view your new widget, go to Widgets.
20. Click the My Widgets tab to show the widget.