Hi,
I want to count two different stats and join them in the same resulting table. Can you remind me how to do this? The string is to complex to duplicate, but I'll illustrate what is there.
index=server application=app page=x OR page=y OR page=z
|stats count as pageloads by page
|stats distinctcount(id) as usercount by page
|lookup excel.csv page AS pagetitle OUTPUTNEW author,creationdate,lastmodified
|table pageloads,usercount,pagetitle,author,creationdate,lastmodified
Yep, just put them in the same stats command.
|stats count as pageloads, distinctcount(id) as usercount by page
You can have all sorts of them piled in there, as long as they're all "by" the same field, which in your case they all were "by page" so that's fine.
Yep, just put them in the same stats command.
|stats count as pageloads, distinctcount(id) as usercount by page
You can have all sorts of them piled in there, as long as they're all "by" the same field, which in your case they all were "by page" so that's fine.
Thanks @Richfez - My mistake was duplication of the by clause.
So
Incorrect
|stats count as pageloads by page, distinctcount(id) as usercount by page
Correct
|stats count as pageloads, distinctcount(id) as usercount by page