- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Count by month
Can you post an example so we can reproduce what you're seeing?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Count by month
Here's a screen shot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.