How to apply function field on a report

[Alon Grod]

Hi,

I created a Report that should show a single score in percentage. I configured this function field (added in attachment) but for some reason Im still getting the count and not the percentage using the function. Why the function field is not applied on the data?

 

[mattystern · Accepted solution]

Hi @Alon Grod 

Might be a data typing issue? I have this working in this format:

EX:

Incident #	Description	User	u_calls_answered_within_20_seconds	u_calls_answered_between_20_30_seconds	u_number_of_calls_answered
INC0385170	Can't login	Bob Test	1		1
INC0385169	Adobe not working	Guest		1	1
INC0385168	No Email	Tim Test	1		1
INC0385167	No Email	Tim Test			1

Note - you result here will always be 1 or 0 in your function field. (1+0) / 1, (0+1) / 1, or (0+0) / 1.

Result: I have 20/67 (0.2985) records populated with either within 20 second or between 20-30 seconds in this PD and I have it rounding to 2.99:

I realize my example has (I am sure) overly-simplified the data, but unfortunately, adding much more complexity will likely yield unfavorable results. Many of the function fields I have setup are more similar to the example on the product documentation. More reading about function fields can be found from the product documentation. 

I hope this helps!

-Matt

[Alon Grod]

@mattystern what did you put for the aggregation? you must choose type of aggregation, can you please show this as well? thanks for the help btw

[mattystern]

@Alon Grod I have this as "average" of the created function field "avg" - see the left of the 0.299 screenshot.

No problem! I could also benefit from how the data is showing on your end - I just used 1 or 0 as a decimal value on my fields. Are these decimal fields, floats, or some other data type?

-Matt