You can try this
SELECT Count (year) as value, Concat(‘year-’, year) as metric, Unix_timestamp(now()) as time_sec FROM peoples Group by year
And config de x-axis as series…
