topic Re: Count by month in Discussions

Count by month

MikeFromEdwards — Tue, 27 Feb 2018 21:22:31 GMT

I have a column of dates indicating when a particular event happened. I want to make a graph showing the count of those events per year-month. I tried the chart object with my statistic being N(DateOfEvent) and the Additional Role being Grouping Month Year[DateofEvent}, but I get an error about too many points.

Re: Count by month

cwillden — Tue, 27 Feb 2018 21:42:11 GMT

Can you post an example so we can reproduce what you're seeing?

Re: Count by month

MikeFromEdwards — Tue, 27 Feb 2018 21:49:51 GMT

Here's a screen shot

https://www.screencast.com/t/TqAsAtRxrD

Re: Count by month

cwillden — Wed, 28 Feb 2018 16:07:42 GMT

If you're wanting to just plot the number of events in a month, couldn't you just plot N(Month-Year) and not have a grouping variable? The way you have it right now its going to plot a bar for every single date in your data table.