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

Reporting on KB usage across set IP range using clickstreams table

edited May 10, 2017 8:38PM in Reporting & Analytics for B2C Service 9 comments

Content

Hi everyone

I've partially solved this problem, however I hope it can be done easier as currently it completely bogs down my Excel since I have to do a lot of filtering outside of RightNow reporting.

The problem I'm trying to solve is identify usage generated by internal stuff across an external interface. I have the IP range of the contact centre, which allows me to identify sessions which were generated internally.

This is the report I've created:

As you can imagine though, the number of lines in a report even for 1 month is pretty high.

Once I have the report, using Excel I identify the sessions which are listed against the set of IP addresses I'm after, delete everything else.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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