Charting by counts of specific text occurrences
I'm trying to create a column chart (and perhaps eventually a stacked column chart) from single table of data. The two fields in question are a date field and a field with a 4-option dropdown. I would like to plot the number of occurrences of each item in the dropdown by month, making four data series on the chart. E.g., I have 10 records in the month of January. 6 entries have option A in the field, 2 have option B and 2 have option C. The four data values in January would be 6, 2, 2, and 0.