Page History

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.

How to Create a Pie Chart Widget

1. Navigate to Widgets on the MSPbots app menu. 
   Image RemovedImage Added
2. Under My Widgets, click Click theNew Widget button.
   
   Image Modified 
3. Select the the Pie Chart widget type on the New Widget window. 
   Image RemovedImage Added
4. When the Widget Builder window appears, provide the followingopens, go to the Basic Setting tab. Provide the following and click Apply:
   
   • Name - Give the widget a name.
   • Description - Give the widget a short description.
   • Role - Select Admin and User. 
     Image Removed
     
5. Click the Save button.
6. Go to Dataset and click the button.
7. • the roles you want to give access to.
     Image Added
     
8. Go to the Dataset tab. Click the  button and select New Layer.
   Image Added
   Image Added
9. On the Dataset window,
   
   1. Select the Dataset containing the information you want to use.
   2. Give a Name for the Datasource (optional).
      Image Added
   3. For Columns Display,
      1. Using the Column Name dropdown, select the field you want to show in the drill through. Click the  button to add more rows.  
      2. Give an Alias and select a Business Type for each.
         Image Added
   4. For Filter,
      
      1. Click the  button and choose between Add Condition and Add Group.
      2. Add all the fields you want to be filtered.
      3. Set a condition/logic for each field using the next 2 dropdowns. For a guide on each options, refer to: What Conditions are Available for Creating Widgets?
      4. Select a logical operator for the filter group (AND or OR).
         Image Added
   5. For Measure,
      1. Click the  button to show the Measure window.
      2. Select a Summary Type.
      3. Select a Field to use in the computation.
      4. Give an Alias for the measure..
      5. Select a Format Type
      6. Click Add.
         Image Added
   6. For Dimensions,
      1. Select a field to be used for grouping the data.
      2. Give an Alias for the measure.
      3. Select a Format Type.
      4. Click Add.
         Image Added
         
   7. Other optional settings are:
      
      1. Order By - Sorts the data based on the selected field. 
      2. Row Limit - Sets a limit on how many rows of data will be shown.
      3. The same 2 options are available on the dataset tab, the difference is that they apply to the pie chart shown instead of the drill-down.
         Image Added
   8. Click Save. 
10. Go to Config tab.
    
    1. Select the Dimension for X-axis. This will determine the grouping used to partition the pie.
    2. Set the Measure for Y-axis. This will be used for the values of each partition.
    3. (optional) For Sub X-axis, another measure can be added to further divide the pie chart.
    4. For Measure Text, select the same Measure used for Y-axis.
    5. (optional) Add a Pie Chart Title.
    6. (optional) Add a Part Name.
       Image Added
11. Click Apply. This will show a preview of the pie chart created.
    Image Added
    

Example: How to Create a Pie Chart Widget that shows the total number of tickets per issue type in the last 7 days

...

1. Navigate to Widgets on the MSPbots app menu.
   Image Added
2. Under My Widgets, click New Widget.
   
   Image Added 
3. Select the Pie Chart widget type on the New Widget window.
   Image Added
   
4. When the Widget Builder window opens, go to Basic Setting tab. Provide the following and click Apply:
   
   • Name - Tickets Per Issue Type
   • Description - This pie chart shows the total number of tickets per issue type in the last 7 days.
   • Role - Admin and User
     Image Added
5. Go to Dataset tab. Click the  button and select New Layer.
   Image Added
   Image Added
6. On the Dataset window,
   
   1. Select the Dataset: Autotask Ticket Statistics
   2. Give a Name for the Datasource (optional).
      Image Added
   3. For Columns Display, add the fields below (format: Column Name - Alias - Business Type
      1. company_name - Company - Text
      2. ticket_number - Ticket Number - Hyperlinks (Additional Steps: Click the paintbrush icon > select Autotask Ticket URL as Format > Click Save)
      3. issue_type - Type - Text
      4. sub_issue_type - Sub-type -Text
      5. create_date - Date Created - Date Time
      6. completed_date - Date Completed - Date Time
         Image Added
         Image Added
   4. For Filter,
      
      1. Click the  button and choose Add Condition.
      2. Select the field create_date for the first dropdown then In for the second one.
      3. For the third dropdown
Click New Layer on the Add New Layer window that appears Autotask / Autotask Ticket Statisticsas Dataset name.
7. Type Count Ticket Number | 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 
     Note: Click the button to add more rows.
     Image Removed
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 icon 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 icon 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
    1. 1. , select Previous > 1 > Weeks (Mon-Sun)
    . Click Save.
    1. 1. 
          Image Added
          
    2. For
    measure, click the button. Select Count for Summary Type and Ticket Number for Field. Select Number for Format Type. Click the paintbrush icon and select Regular (1,000) as Format. Click Save and Add.
    Image Removed
13. For Dimension, click the button and select issue type for Fields. Click 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 for the 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.

...

1. 1.  Measure,
      1. Click the  button to show the Measure window.
      2. Select Count for Summary Type.
      3. Select Ticket Number for Fields.
      4. Type Ticket Count as an Alias.
      5. Select Number for Format Type.
      6. Click Confirm
         Image Added
   2. For Dimensions,
      1. Select Type for the field.
      2. Type Issue Type as an Alias.
      3. Select Text for  Format Type.
      4. Click Confirm
         Image Added
   3. Click Save. 
2. On the Dataset tab, for Order By, click the  button and select Ticket Count.
   Image Added
   
3. Go to Config tab.
   
   1. Select Issue Type for X-axis.
   2. Select Ticket Count for Y-axis.
   3. Select Ticket Count for Measure Text.
      Image Added
4. Click Apply. This will show a preview of the pie chart created.
   Image Added