Question

for each observation of a country, there is a column storing the month (such as january) and a column storing the year (such as 2012). what visual recipe could be used to aggregate the data into yearly totals?

Answer 1

A possible visual recipe to aggregate the data into yearly totals is a bar chart or a line chart with the year on the x-axis and the total value on the y-axis. Each bar or point on the chart would represent the total value for that year, and the trend over time could be easily observed. This would allow for quick identification of any patterns or changes in the data over time.