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

Use Logged In in an If Function in Analytics

Received Response
32
Views
1
Comments
edited May 29, 2015 5:20PM in Reporting & Analytics for B2C Service 1 comment

Content

I am working on building a report, and the team has asked me to group incidents for a team based on who they are assigned to. They want to groups, all incidents that are assigned to the person that is Logged In, and then the second group being a list of all other incidents that are assigned to other people.

I created a column that says if(incidents.assgn_acct_id='Logged In','Logged In','Other'). The syntax is valid, but it doesn't seem to recognize the 'Logged In' as a record, and everything is returned as Other.

I know that you can filter incidents based on the Logged In criteria, but is there a way to return that value within a function?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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