Using Function Fields in Report Aggregates

[johnfeist]

I have a function field (Resolution Days) that converts calendar_stc into days.  When I try to use it as a column in a report, all is good.  However, when I try to use Resolution Days in a pie/donut chart where the aggregation is Average Resolution, I get an ACL violation.  Is there a restriction around using function fields that way?

[Gabor10]

Hi @johnfeist ,

know this thread has been as eventful as watching paint dry... but I have the same issue and I was wondering if you ever got this to work or if you have any additional information since?

Thanks!

[Craig Tinsley]

I'm having the same problem - but with Score reports .. It returns an ACL error when I attempt to aggregate a datadiff function field, BUT I can see them in my list reports no problem. Hopefully someone takes note of these questions and responds - I haven't found anything, anywhere to help me with this.

[johnfeist]

I haven't gotten very far on getting this solved.  I suspect that what is happening is that there are too many values involved and that the ACL error is a false flag since I don't know how a read or report_view ACL can distinguish how the returned data are being used.

[Craig Tinsley]

FWIW: I submitted a ticket to SN support today, and they're answer was, "It's a known issue - you need to add ACLs to the specific fields for which your function field is calling" (they referred me to this: https://docs.servicenow.com/bundle/vancouver-platform-security/page/administer/contextual-security/c...).

I followed their instructions, and I'm still receiving the error - not sure whether it's because there's an overriding ACL, OR I'm missing some "contributing field" ACL. I'll let you know what I find-out.