I have 1 measurement, 1 tag (primary key) besides ‘time’ and 4 fields.
I’m storing web server requests data: short(request specific unique key), referrer, country, device, os
I need to visualize daily/weekly/monthly requests count, top 10 countries, top 10 referrers
Per each client I’m getting daily about 25 Million requests. Now I have 4 clients but going fwd the number will be added.
Could you please help on way how to store this kind of data and how to query needed info.