Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Navigate to Widgets on the MSPbots app menu. 
    menu widgetsImage Added
  2. Click the New Widget button and select .

    new widgetImage Added 
  3. Select the Pie Chart widget type. 
    select pie chartImage Added
  4. 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. 
      basic setting widgetImage Added
  5. Click the Save button.
  6. Go to Dataset and click the (plus) button.
  7. Click New Layer on the Add New Layer window that appears Autotask / Autotask Ticket Statisticsas Dataset name.
  8. Type Count Ticket Number | Autotask Ticket Statistics as Datasource name.
  9. Under Columns Display, select the following as column names:
    • company_name
    • ticket_number
    • issue_type
    • sub_issue_type
    • create_date
    • completed_date 
      Note: Click the (plus) button to add more rows.
      dataset widgetImage Added
  10. Give each entry an Alias.
  11. 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
  12. Under Filter, click the (plus) button > +Add Condition.
  13. Select create_date > in. For the Value field, select Previous > 1 > Weeks (Mon-Sun). Click Save.
  14. For measure, click the (plus) button. Select Count for Summary Type and Ticket Number for Field. Select Number for Format Type and select Regular (1,000) as Format. Click Save and Add.
    measure widgetsImage Added
  15. Click the Save button on the Dataset window.
  16. Click the Config button on the left pane.
  17. Select Issue_type for the X-Axis and Ticket Count as Y-Axis.
  18. Select Ticket Count for the Measure Text field.
  19. Give the Pie Chart a Title.
  20. Click Apply.
  21. To view your new widget, go to Widgets.
  22. Click the My Widgets tab to show the widget.

...