Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Check the attached.
Check the attached.
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!
Here is the solution with front end expression.