statistics by month

[aintechco]

Hi

Try to build a table for the below requirement

First Column: url

2nd Column: jun2021

3rd Column: May2021

.....

URL             June2021           May2021

wiley            1000                     500

IEEE              1000                     400

Thanks

Sajid

[ITWhisperer]

| table URL June2021 May2021

[aintechco]

Thanks for replay

I don't have the month field in the logs.

having the only URL

the requirement is like below

per month count stat per url.

Regards,

Sajid

[ITWhisperer]

It can't be only the URL. Perhaps if you shared a few anonymised events from the ingested logs we might be able to make a bit of progress otherwise it is a bit of a guessing game.