Is it possible to add a runtime field which is the percentage of two different columns in the same row?

Hello,

I see scripted fields has been deprecated in 7.13 and it is suggested that we use runtime fields.

I was wondering if it is possible to add a runtime field which calculates the ratio of two different column values in the same row?

The following is a simple example:

I can generate a table which has the rows separated by Call Center name and two columns which are the sum of Incoming calls and sum of Outgoing Calls.

The next two columns are the ones I would like to generate:

  • % Incoming Calls = sum Incoming calls / (sum Incoming calls + sum of Outgoing Calls)

  • % Outgoing Calls = sum of Outgoing Calls / (sum of Incoming calls + sum of Outgoing Calls)

Thanks in advance for your help!

Mike

Hi @Amphagory ,

I think you can achieve that using Lens new Formula's feature.
As a basic rule of thumb, runtime fields are pretty good at enriching fields data while Lens Formula is best to to math calculations with aggregations.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.