N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
...
- Navigate to Widgets on the MSPbots app menu.
- Click the New Widget button and select the Card number widget type.
- 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.
- Click the Apply button.
- Go to Dataset and click
button.
- Click New Layer on the Add New Layer window that appears.
- On the Dataset window,
- Select ConnectWise Manage Ticket Statistics - Cloud as Dataset name because the widget will show the total number of tickets.
- Give a Name for the Datasource. Under Columns Display, select ticket_id for Column Name. Type Ticket ID as Alias and select Number for Business Type.
- Add a new column and select resource_list for Column Name. Type Tech for Alias and select Text for Business Type.
- Add another column and select last_update for Column Name. Type Last Update for Alias and select Date Time for Business Type.
- Under Filter,
- Click
> Add Condition.
- Select last_update > in.
- Click on the Value field. For Time Variate, select Last > 7 > days.
- Click Save.
- Click
- For measure,
- Click
to show the Measure window.
- To get the total tickets, select count for Summary Type, and ticket_id for Fields.
- Give an Alias, say Total Tickets, and select Number for Format Type.
- Click Add.
- Click
- Click Save.
- Go to Config. Under Measure, select Total Tickets.
- Click Apply. The preview for the Total Tickets Updated Last 7 Days widget will appear.
- Click Apply.
- To view your new widget, go to Widgets.
- Click the My Widgets tab to show the widget.
Content by Label | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
Overview
Content Tools