Insights custom fields with QueueItem Creation Time filter

Help Insights
3

To implement this in UiPath Insights, you can achieve the desired filter using the following steps:

1. Custom Field in Insights:

  • The formula you’ve shared needs to compare the creation_time of queue items against the current time within the past 30 minutes. Since Insights supports calculated fields, you can utilize the DATEDIFF function to calculate the time difference in minutes.

2. Revised Formula:

Here’s how you can create a custom field for your use case:

sum(if(DATEDIFF('minute', ${queues.creation_time}, NOW()) <= 30, 1, 0))
  • DATEDIFF('minute', ${queues.creation_time}, NOW()): Calculates the time difference in minutes between the queue creation time and the current time.
  • <= 30: Ensures only those records from the last 30 minutes are considered.
  • sum(if(..., 1, 0)): Counts the records that satisfy the condition.

3. Setting Alerts:

  • Once you’ve added the custom field:
    1. Go to the Alerts section in Insights.
    2. Create a new alert and select the dashboard or widget containing the custom field.
    3. Define the alert trigger (e.g., when the sum exceeds a specific threshold).

4. Testing:

  • Validate the formula by applying it to a sample dataset to ensure it’s calculating the intended results.
  • Check time zone configurations in Insights to ensure accuracy.