Reporting on KB usage across set IP range using clickstreams table
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.
Tagged:
0