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

Help with expression

edited Aug 10, 2016 7:02PM in Reporting & Analytics for B2C Service 4 comments

Content

Hello,

I'm hoping someone can help me with an expression that I'm trying to edit within a report.
I've attached an export of the report.

I need to group by external versus internal IP's to gauge how many internal employees hit our help desk each day/month.  

I want the report to show two values (1) INTERNAL (2) EXTERNAL

I've been able to do this using just one of our internal IP's, as shown below and it works fine and shows values/counts for INTERNAL as well as EXTERNAL.

My Expression was:
if(clickstreams.context1 = 'IP#1', 'INTERNAL', 'EXTERNAL')

The problem happens when I try to add our other internal IP's to this expressions, as it t then only returns the external value and does not show any internal counts.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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