Let's say I have dimensions like country, content, subscriptionType, and I'd like to get the 3 most common fields grouped by platform say web, app, etc. How would I go about doing this?
An ideal output would be something like this
----- |country |content |subscriptionType
web|us,uk,camusic,video,audio|seo-trial,sem-trial,perf-trial
app|us, ca, ch|music, video, audio|seo-trial,sem-trial,perf-trial
Using the TOP command is like this.
(your search)
|top 3 country,content,subscriptionType by platform
results:
app,us,music,seo-trial,100
app,ca,music,sem-trial,50
app,ch,music,perf-trial,10
web,us,music,seo-trial,150
web,uk,video,sem-trial,100
web,ca,audio,perf-trial,30
That would be the top of those dimensions together, but how do we achieve top of each dimension independently?
Is it like this?
(your search)|top 3 country by platform
| append [search (your search)|top 3 content by platform]
| append [search (your search)|top 3 subscriptionTypeby platform]
| fields - count percent
|stats list(*) as * by platform