I have a measure that returns the date of the earliest gift given by a person (ID) with the unique identifier 'PAT':
=Min({<UNIQUE IDENTIFIER]={'PAT'}>} [DTE])
Now, I would like to create a measure that returns the date of the earliest gift made AFTER the one calculated above for the same person (ID). To do this, I am trying to Aggregate by ID within set analysis as follows:
However, this results in null values for every ID.
I find this strange since when I test the Aggr() function outside of a Set Analysis, it returns the date I expect. But when I put it in the Set Analysis, it results in the Preview looking like:
=Min({<[DTE] = {">-}>} [DTE])
Does anyone know why this is? Is Aggr() not allowed within Set Analysis?
I also tried your aggr out of the set analysis and it was not working. Maybe I am mistaken by why would you aggr by ID when you are looking at a person with a unique identifier?
Thank you for trying that. Using [UNIQUE IDENTIFIER] in my Aggr didn't seem to work.
The reason I am trying to use Aggr() is because if I don't, then the Set Analysis is looking at the Minimum date for ALL records with a unique identifier of 'PAT'. However, I would like to look at the minimum date with unique identifier 'PAT' for each row (ID) individually and use that value in my set analysis instead.
Then as i mentioned, it is doing the math: $(=4/4/2025). I can't test it right now, to demo you where to put quotes etc, but in these cases, some times i convert (or create another field in the model) to num.
in that case it does not make sense. Using $(=) already is looking at minimum for whole data set (and not for the row of the dimension in the table). I am not sure about your data model and how you have built your app but reading your requirement it seems you only need second minimum date:
Min({<UNIQUE IDENTIFIER]={'PAT'}>} [DTE],2)
Obviously parameter in Min() function can be used for that and you dont need any aggr() function.... however you will need ID as a dimension in the table where you want to display it.
To give you definite answer we would need to understand how you would like to use this measure. Putting it in the table is very different to putting it to KPI object as table has its dimensionality which needs to be considered when measure like this is created.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
