You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

? about Incident Transactions Counts from Cookbook

edited Jul 13, 2016 3:32PM in Reporting & Analytics for B2C Service 3 comments

Content

First, let me just say thank you for this report. It has solved an outstanding  "want" that our business had for some time now.



The last piece that we need to resolve is as follows.



Is there a way to subtract two columns and place the output in a different/new column?



Columns:



C1 = #Response Sent

C2 = #Created

C3 = # Prod (Need output to be the #Responses MINUS #Created)



I read the article in the Analytics Cookbook here: https://cloudcustomerconnect.oracle.com/posts/42317909a8 and saw your reference to Special functionality usage: and tried the following, but it doesn't work properly if the value for #Created is zero.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!