Vizualization: number of records

[von Horst]

I have a list with elements: country, city, itemname
I want to show vizualization about one specific country that shows the number of records belonging to that country as a chart.
How can I do that?

It should look like this:

vertical axis: count of element itemname
horizontal: city element
data restricted/filtered to one country of many

 

[troester]

I would
- create a MySQL view, something like
SELECT count(*) as count, city FROM your-list GROUP BY city

- create a Fabrik list pointing to this view
- create a chart viz with this list + a prefilter selecting your country (or a required list filter if the user should be able to choose the coountry)