Function 'AVG' should have 1 argument(s) instead of 2 argument(s)

Question & Answer
, ,
1

Hi Team,

I’m using the below simple average function in a calculated field, but getting the subjected error.

avg({handle_time}, [{contact_handled}])

“Function ‘AVG’ should have 1 argument(s) instead of 2 argument(s)”

The documentation indicates we can use group-by level as a second argument in AVG function, but not sure why it’s throwing this error.

Any thoughts?

Thanks,
Khurram

2

@Khurram.Awan - Can you please confirm that the handle_time is a decimal field whereas {contact_handled} is designated as a dimension? Please let me know.

image

I tried to replicate the solution at my end and it is working perfectly as expected.

image

1 Like