Create a chart to see new members by month

[eric10]

So I’m trying to create a simple line or bar chart to show me how many new members I gained each month. Basically I want to have the last 12 months along the bottom, and then count how many members started in each one of those. I plan to do this based off a User field “Member Since” which is a date field.

When using the Line/Bar Chart the only option of expression it gives me is a number field, but I don’t want to use that field.

Is there a way to do this?

[eric10]

Did I put this in the wrong help group? Anyone an expert on charts?

[mikeloc]

Hi there, @eric10… if I understand your post correctly, I believe something like this would do the trick.

Oh, and make sure any privacy rules you have in place on the User data type don’t conflict with the search and/or access to the member since field.

Hope this helps.

Best…
Mike

[eric10]

Thank you for the response. I’m not able to select the Value Expression you have.

Side note I decided to go with Membership Data Field instead of Users, and there the start date is listed as Membership)start_date instead of Member_since.

Anytime I select Current Points in Value Expression it auto adds Membership_start_date, and it’s red and I can’t add count after that.

[mikeloc]

Have you added the count aggregation in the Group By dialog (refer to the left side of my screenshot)?

[eric10]

I missed that. You make this stuff look so easy. Is there anyway to make it show the number of new members when you hover over it instead of the date?

[mikeloc]

It is showing the number of new members… it’s 11, right?

[eric10]

Sorry, can you get it to just show without the date. Just so it’s clearer. I can see the date below.

[mikeloc]

Yes, check these two boxes.

[bennymac1]

hey all, just wanted to pass along my thanks for you both working this out in the forum. I was stuck on a similar set up, but wanted to see the user base growing over time (total user count over time, months on the x-axis, total user population on the y-axis). for some reason, the user count seemed to be off by a month (i.e. the user count for the month of July 2024 was displaying the user count which actually should have been shown for the month of June 2024).
in case anyone else gets stuck with that, and wants to build the same set up as me, I’ve provided some screenshots below now that I’ve got it sorted out correctly:

It looks like I had the value expression set up incorrectly. i previously had ‘do a search for users, where created date <= current points creation date’, where it should have been ‘do a search for users, where created date <= current point’s creation date + months:1’ or plus 30 days or whatever you define your month to be. I had expected the current point’s creation date to include all of that month, but it looks like it doesn’t, for whatever reason. it seems to only include maybe the first day, or only up to the start of that month, even though I’ve used the <= symbol.