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, …

Managed with the below query: sum(if(${queues.processing_exception_type} = “BusinessException”, sum(if(diff_minutes(${queues.creation_time}, now()) <= 60, 1, 0)), 0))

Insights custom fields with QueueItem Creation Time filter

Help Insights

sarathi125 (Parthasarathi) December 11, 2024, 3:41pm 5

Hi @Shakib,

I am getting exception with the formula,

Topic		Replies	Views
HI, I am trying to create a uipath insight dashbard based on queues and calculate average transaction time, But some how the average time is calculated incorrectly if a longer date range is selected Insights orchestrator , insights	1	199	March 31, 2024
My ROI foruma is not working in aggregate.. only works when filtering on 1 Queue Name.. what am I doing wrong here? Insights question , insights	4	1430	November 10, 2021
Grouping Data Points within Dashboard Insights question	4	1758	March 4, 2022
How to Date Diff across Two Dates Spanning Days Insights question , insights	3	1417	November 8, 2021
Measure "customFilter" has an invalid type "number" Insights question , insights	1	659	February 9, 2023

Insights custom fields with QueueItem Creation Time filter

Related topics