Page History

...

1. Navigate to Widgets on the MSPbots app menu.
   
2. Under My Widgets, click New Widget.
   
   
3. Select the Card Number widget type on the New Widget window.
   
4. When the Widget Builder window opens, go to the Basic Setting tab. Provide the following and click Apply:
   • Name - Total Tickets Updated Last 7 Days
   • Description - Displays the total number of tickets that were updated within the last 7 days.  
   • Role - Select Admin and User.
     
     
5. Go to the Dataset tab. Click the  button and select New Layer.
   
   
   
6. On the Dataset window,
   
   1. Select the Dataset: ConnectWise Manage Ticket Statistics - Cloud
   2. Give the data source a name and enter it in the Show datasource name as field (optional).
      
   3. For Columns Display,
      1. Using the Column Name dropdown, select ticket_id. Type Ticket ID as Alias and select Number for Business Type.
      2. Add a new column and select resource_list for Column Name. Type Tech for Alias and select Text for Business Type.
      3. Add another column and select last_update for Column Name. Type Last Update for Alias and select Date Time for Business Type.
         
   4. For Filter,
      
      1. Click the  button and choose Add Condition.
      2. Select the field last_update for the first drop-down then In for the second one.
      3. For the third dropdown, select Last > 7 > days.
         
         
   5. For Measure,
      1. Click the button to show the Measure window.
      2. Select Count for Summary Type.
      3. Select Ticket ID for Fields.
      4. Type Total Tickets as an Alias.
      5. Select Number for Format Type.
      6. Click Add.
         
   6. Click Save. 
      
      
7. Go to the Config tab. 
   1. Select Total Tickets for Measure.
   2. Add Tickets Updated as Footer Title.
      
8. Click Apply. This will show a preview of the Total Tickets Updated Last 7 Days card number.