AnsweredAssumed Answered

Charting by counts of specific text occurrences

Question asked by NicholasWelander on Jan 19, 2015
Latest reply on Jan 19, 2015 by NicholasWelander

Title

Charting by counts of specific text occurrences

Post

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.

Outcomes