I have all the relevant data I need from a single source but I am wanting to present it in a way that I can't get it to work. I want to show what departments/user/and the count that are using specific URLs and put them on a single line with the corresponding URL.
Team1 User1 URL1 Count
Team2 User4
Team3 User9
------------------------------------------------------------------------
Team1 User3 URL2 Count
Team4 User4
User12
User16
User17
------------------------------------------------------------------------
Team3 User1 URL3 Count
Team6 User3
Team10 User12
------------------------------------------------------------------------
Let me know if I need to clarify anything
How do you envision Team and User aligned if they are both arrays? Your illustrated results suggests that you don't care about this part. If so, would this do?
| stats count values(Team) as Team values(User) as User by URL
Didn't think that far ahead but Ill be making a dashboard for this so I think it would be easier if I separated them instead of trying to put it all in one search. What you just did works perfectly so thank you so much for that!
How do you envision Team and User aligned if they are both arrays? Your illustrated results suggests that you don't care about this part. If so, would this do?
| stats count values(Team) as Team values(User) as User by URL