cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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

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