nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

52273_en-US

liliconcom

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.

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.

Re: Count by month

Here's a screen shot

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

Re: Count by month

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

Comments

There are no comments yet