Solved

Advanced Analytics - Using Explore to create a report

  • 27 November 2023
  • 3 replies
  • 31 views

Badge

Hello, I'm new to Advanced Analytics and I'm testing out my first report. I'm creating a simply report which has the following fields:

 

  • User
  • Netskope Host POP
  • Source IP Address

 

I'm using Page events under Data Collection.

 

The data shows up in the report, but the issue I'm having is that instead of listing all users in their individual row in the table the report is listing all users in 1 field separated by columns. The same is true for the Source IP Address.

 

How can I resolve this issue?  

icon

Best answer by qyost 27 November 2023, 16:15

View original

3 replies

Userlevel 5
Badge +16

Any chance you're using the "Aggregate -> List of Unique values" for your User field rather than the Dimension itself?

 

 

Badge

Thanks for your assistance. You hit the nail on the head !!!!

Userlevel 5
Badge +16

Glad to help.   I had to ask a couple weeks ago how to get the formatting you stumbled into.  😆

Reply