Page History

This article shows the following steps on how to create a card number widget that shows the total tickets updated in the last 7 days. It applies to MSPbots users with a ConnectWise Manage integration.

To create a target card widget: 

:

...

How to Create a Card Number Widget

1. Navigate to Widgets Navigate to Widgets on the MSPbots app menu.
   Image Added
2. Under My Widgets, click New Widget.
   Image Added
   
3. Select the Card Number widget type on the New Widget window.
   Image AddedClick the New Widget button and select the Card Number widget type.
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.the roles you want to give access to.
     Image Added
5. Next, go to the Dataset tab. Click the  button and select New Layer. 
   
   Image Added
   
   
   Image Added
6. On the Dataset window,
   
   1. Select the Dataset containing the information you want to use.
   2. Give the data source a name and enter it in the Show datasource name as field (optional).
      Image Added
   3. For Columns Display
      1. On the Column Name drop-down, select the field you want to show in the drill through. Click the  button to add more rows.  
      2. Give each row an Alias and select a Business Type for each.
         Image Added
   4. For Filter
      
      1. Click the  button and choose Add Condition or Add Group.
      2. Add all the fields you want to filter.
      3. Set a condition or logic for each field using the next two drop-downs. For a guide on each option, 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.
   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.
   8. Click Save. 
      
      
7. Next, go to the Config tab.
   
   1. Select the Measure to be shown in the card number.
   2. Set the Value Font Weight and Color.
   3. Add a Footer Title and set its Font Color (optional). 
      Image Added
8. Additionally, go to the Condition tab to set Conditional Formatting.
   1. Add a rule and assign a name.
      Image Added
      
   2. Set the conditions for the rule.
      
      Image Added
   3. Select the text color to be applied once conditions are satisfied.
      
      
9. Click Apply. This will show a preview of the created card number widget.
   Image Added

Example: How to Create a Card Number that shows the total tickets updated 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 Card Number widget type on the New Widget window.
   Image Added
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.
     Image Added
     
5. Go to the Dataset tab. Click the  button and select New Layer.
   
   Image Added
   Image Added
6. Click the Apply button. 
7. Go to Dataset and click button. 
8. Click New Layer on the Add New Layer window that appears. 
9. On the Dataset window,
   
   1. Select the Dataset: ConnectWise Manage Ticket Statistics - Cloudas Dataset name because the widget will show the total number of tickets.
   2. Give the data source a name and enter it in the Show datasource name as field (optional).
      Image Added
   3. For Columns Display,
      1. Using the Column Name dropdown, select ticket_id. Type Ticket ID 
      a Name for the Datasource. Under Columns Display, select ticket_id for Column Name. Type Ticket ID
      1. 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.
         Image Added
   Under
   1. For Filter,
      
      1. Click the 
      >
      1. button and choose Add Condition.
      2. Select the field last_update
      > in
      1. for the first drop-down then In for the second one.
      Click on the Value field. For Time Variate, select
      1. For the third dropdown, select Last > 7 > days.
         
      Click Save. 
      1. Image Added
         
   2. For
   measure
   1. Measure,
      1. Clickthe button to show the Measure window.
      To get the total tickets, select count for Summary Type, and ticket_id
      1. Select Count for Summary Type.
      2. Select Ticket ID for Fields.
       
      Give an Alias, say Total Tickets, and select
      1. Type Total Tickets as an Alias.
      2. Select Number for Format Type.
      3. Click Add.
         Image Added
   2. Click Save. 
      
      
10. Go to the Config . Under Measure, select Total Tickets. tab. 
    1. Select Total Tickets for Measure.
    2. Add Tickets Updated as Footer Title.
       Image Added
11. Click Apply. This will show a preview of Click Apply. The preview for the Total Tickets Updated Last 7 Days widget will appear.
12. Click Apply.
13. To view your new widget, go to Widgets.
14. Click the My Widgets tab to show the widget.

...

1. card number.
   Image Added