What's in this page:
Introduction
MSPbots has prebuilt widgets to help organize your reports on one page. If these widgets do not fit your requirements, you can create custom widgets and use the guide below in configuring datasets.
Here are the filter conditions that you can use when creating custom widgets.
Required permissions
Only users with admin privileges can create a widget and subsequently use this article.
Filter Conditions
| No. | Conditions | Description |
| 1 | Is Empty | Pulls data with a null value. |
| 2 | Is Not Empty | Pulls data with a value. |
| 3 | Is Blank | Pulls data with an empty string. |
| 4 | Is Not Blank | Pulls data with a non-empty string. |
| 5 | Equals/Equal To/Equal | Pulls data that is equal to only one specific value. |
| 6 | Not Equals/Not Equal To/Not Equal | Pulls data that is not equal to one specific value. |
| 7 | Contains | Pulls data where the field's value matches the input; functions like " ilike '%input%' ". |
| 8 | Not Contains | Pulls data where the field's value does not match the input; functions like " not ilike '%input%' ". |
| 9 | Start With | Pulls data where the first part of the field's value matches the input; functions like " ilike 'input%' ". |
| 10 | End With | Pulls data where the last part of the field's value matches the input; functions like " ilike '%input' ". |
| 11 | Not Start With | Pulls data where the first part of the field's value does not match the input. |
| 12 | Not End With | Pulls data where the last part of the field's value does not match the input. |
| 13 | IN | Pulls data that is equal to any value in the list; allows choosing a list of values. |
| 14 | Any | Pulls data that contains any value from the list; allows choosing a list of values. |
| 15 | Not IN | Pulls data that is not equal to any value in the list; allows choosing a list of values. |
| 16 | Any IN | Pulls data that contains any value from the list; allows choosing a list of values. |
| 17 | Match | Uses regular expression; functions similarly to "Contains". |
| 18 | Not Match | Uses regular expression; functions similarly to "Not contains". |
19 | = | Pulls data that is equal to only one specific value. |
20 | > | Pulls data that is greater than only one specific value. |
21 | >= | Pulls data greater than or equal to a specific value. |
22 | < | Pulls data less than a specific value. |
23 | <= | Pulls data less than or equal to a specific value. |
24 | != | Pulls data that is not equal to one specific value. |
25 | Later Than | Pulls data later than a specific value. |
26 | Earlier Than | Pulls data earlier than a specific value. |
27 | Less Than | Pulls data less than a specific value. |
28 | Time of Day | Pulls data at a specific time of the day. |
29 | Between | Pulls data between two points in time. |
Time Variate
| No. | Category | Name | Description |
|---|---|---|---|
| 1 | Time attribute | Last | Refers to the past time. For example, if Last 2 Weeks (Mon-Sun) is set, it means the past two weeks' Mondays to Sundays, totaling 14 days. If Include this is checked, it includes the present day as well. |
| 2 | Next | Refers to the upcoming time. For example, if Next 2 Weeks (Mon-Sun) is set, it means the next two weeks' Mondays to Sundays, totaling 14 days. If Include this is checked, it includes the present day as well. | |
| 3 | Current | Refers to the present time. | |
| 4 | Previous | Refers to a specific time or period in the past. For example, if previous 2 Weeks (Mon-Sun) is set, it means the second week before, starting from Monday to Sunday, totaling 7 days. | |
| 5 | Time unit | BusinessDay | Refers to working days, which may not necessarily be Monday to Friday. Some companies' working days include Saturdays. |
| 6 | Minutes | - | |
| 7 | Hours | - | |
| 8 | Days | - | |
| 9 | Weeks (Mon-Sun) | A week from Monday to Sunday. | |
| 10 | Weeks (Sun-Sat) | A week from Sunday to Saturday. | |
| 11 | Weeks (Sat-Fri) | A week from Saturday to Friday. | |
| 12 | Weekend | Refers to Saturday and Sunday. | |
| 13 | WeekDay | Refers to Monday to Friday. | |
| 14 | Months | - | |
| 15 | Quarter | - | |
| 16 | Years | - | |
| 17 | FinancialYear(QA) | The specific day that marks the beginning of each financial year. | |
| 18 | Include this | If this option is checked, pulling data will include the data for the current day. |
Time
Please select a time accurate to the second, starting from the year.
Slicer
- Check Slicer to configure it.
Ignore this filter if the Slicer does not exist in the dashboard.
- Click the blank box to the right of Slicer.
- Select the filtering criteria from the Select dropdown menu.
- If the desired filter criteria are not available in the Slicer, please click Advance to customize advanced filtering conditions.
- Enter the advanced conditions in the blank box.
- If Ignore Filter is checked, the filtering conditions configured before the Slicer will be disregarded; only the Slicer will be effective.
- If Ignore Filter is checked, the filtering conditions configured before the Slicer will be disregarded; only the Slicer will be effective.