Insights custom fields with QueueItem Creation Time filter

[sarathi125 (Parthasarathi)]

Hi All,

I am trying to create a dashboard in Insights and also I need an alert based on the failures within last 30 mins. So I am creating a custom field and trying to add the below filter. But I want this to be compared with time (in minutes). Any help…

sum(if(${queues.creation_time} = now(), 1, 0))

[sagar.singh1 (Sagar Singh)]

Hi @sarathi125 ,

Try the mention query.

sum(if(${queues.status} = ‘Failed’ AND ${queues.creation_time} >= now() - interval ‘30 minutes’, 1, 0))

[Shakib]

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.

[sarathi125 (Parthasarathi)]

Hi Sagar,

I am getting syntax error with this,

[sarathi125 (Parthasarathi)]

@Shakib

sum(if(DATEDIFF('minute', ${queues.creation_time}, NOW()) <= 30, 1, 0))

Hi @Shakib,

I am getting exception with the formula,

[sagar.singh1 (Sagar Singh)]

Hi @sarathi125 ,

Try the mention query.

sum(if(${queues.status} = ‘Failed’ AND ${queues.creation_time} >= now() ‘30 minutes’, 1, 0)

[sarathi125 (Parthasarathi)]

Managed with the below query:

sum(if(${queues.processing_exception_type} = “BusinessException”, sum(if(diff_minutes(${queues.creation_time}, now()) <= 60, 1, 0)), 0))