cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Count by month

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
cwillden
Super User (Alumni)

Re: Count by month

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.

-- Cameron Willden

View solution in original post

3 REPLIES 3
cwillden
Super User (Alumni)

Re: Count by month

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

-- Cameron Willden

Re: Count by month

2018-02-27_1348
Free online storage and sharing with Screencast.com. 2 GB of storage and 2 GB of bandwidth per month for free. We won't compress, alter or take ownership of your content.
cwillden
Super User (Alumni)

Re: Count by month

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.

-- Cameron Willden