Create panels on the fly in a dashboard

[hmahendrakumar]

Here is my usecase(translated):

eg:-

I have the list of countries in a file countries.txt

It has the following content

USA

Mexico

Canada

and i have a generic search like this

index=$country sourcetype=tweets earliest=-7d@d | timechart span=1d count

I need to lookup this file and since it has 3 entries my dashboard should have three panels(chart or table or single)

with corresponding searches

index=USA sourcetype=tweets earliest=-7d@d | timechart span=1d count

index=Mexico sourcetype=tweets earliest=-7d@d | timechart span=1d count

index=Canada sourcetype=tweets earliest=-7d@d | timechart span=1d count

Is this possible ? Please let me know if I am not clear enough.

[IT_Bullgod]

Instead of multiple panels, why not have a single panel? You can dynamically list each country as a series on a single chart - which is much cleaner. If there's 2 countries in the result, there's two series on the chart. If there's lots of results, use a limit so you see the top 10 or top 100. Enable drilldown so your user can dive into the specific country as needed.

[hmahendrakumar]

Yes. That would work if I have few countries with one or two metrics to show. But, in my case I have arnd 20 countries and more than 1 metric to show.I think I oversimplified my use case.