Page History

...

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 Save button.
5. Go to Dataset and click the button.
6. Click New Layer on the Add New Layer window that appears Autotask / Autotask Ticket Statisticsas Dataset name.  
7. Type Count Ticket Numer Number | Autotask Ticket Statistics as Datasource name.
8. Under Columns Display, select the following as column names:
   • company_
   name 
   • name
   • ticket_number
   • issue_type
   • sub_issue_type
   • create_date
   • completed_
   date
   • date 
     Note: 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). Click Save.
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. Save and Add.
14. Click the Save button on the Dataset window.
15. Click the Config button on the left pane.
16. Select Issue_type for the X-Axis and Ticket Count as Y-Axis.  
17. Select Ticket Count for the Measure Text field.  
18. Give the Pie Chart a Title. 
19. Click Apply.  
20. To view your new widget, go to Widgets.
21. Click the My Widgets tab to show the widget.