Get first entry for each user and sum on MonthYear

[RodrigoRodrigues]

I need to get the minimum date for each user, and sum the number of dates that are on the same month/year.

Let me give a quick example this is a sample set: 



I need a formula that makes a table like this:



I already got the MonthYear, but I am having trouble to get the myFormula part.

Basically I need to get the MonthYear of the first entry of the user and sum with all other users that have the same MonthYear for their first entry. 

So we have 1 for Dec-2018 (Cesar - 11/12/18 -> First Entry)
2 for Jan-2019 (Julio 07/01/19 -> first entry and Bruno 25/01/19 -> First Entry)

I hope that what I need to achieve is clear.

Thanks!

[neelamsaroha157 · Accepted solution]

Check the attached.

[RodrigoRodrigues]

Thanks for the answer.

It actually worked as expected on your attachment, but I could not make it work on my file.

I have some doubts about your attached file.



Where are the fields MinDate coming from? I don't understand how this works.

Also, on my file I was using sum and aggr to try to get what I want. Is there a way of doing the same stuff you did on the load using some formula that is not on the load script?

Thanks!

[neelamsaroha157]

Here is the solution with front end expression.