A template chart configuration file for you to use!

{
	"database" :{
		"id": ""
	},
	"chart": {
		"title": [
	    {
	      "text": "",
	      "left": "center"
	    },
		],
		"tooltip": {
			"show": true
		},
		"dataset":{
			"source": []
		},
		"legend": {
			"show": true,
			"bottom": "5%"
		},
		"series" : [{
			"name": "",
			"type": "pie",
			"label": {
        "show": true
      },
			"encode" : {
				"itemName": "name" ,
				"value": "value"
			}
		}]
	},
	"data_query": {
		"id": ""
	}
}

SELECT 
	DISTINCT "" as "name", -- Select the labels 
	count(*)::INT as "value",
FROM :database
WHERE 1=1
--  Add any filtering here
GROUP BY "name";