I created a table with Countries and Flags and a field with number of users (noUsers) belonging to the specific country.
I would like to populate the last field (noUsers) with a query as select country,count(*) from table1 group by country and show in front the country-name, flag and nousers belonging to each country and then link the country-name to show the cities and noUsers belonging to this city... If the user click on a City field, then shows the users of this city.

Is this possible to do with this nice tool you have?

Please give me an idea how to do this?

Thank you very much

It is very specific request.

If you want to do this, just complete your query in the model, and then show the result in the template.

The more options we'll have in Cook, the more complex will be the interface.

So, for practical reason, I don't add this feature to the roadmap.

It is nice to open your component and write inside a little bit.