Count Distinct numbers using FirstSortedValue

[rustyfishbones]

Hi All,

I am trying to do a count using the below expression

=AGGR(count ({<DataValue = {"True"}, ParameterChildName = {"SigPod_AirTest_1_Status.Test_Passed"}, EntryTimestamp = {'$(=MIN(EntryTimestamp))'}>} distinct [Serial Number]),EntryTimestamp)

The result returns 1

should I be using FirstSortedValue in the Set Expression

I am trying to count the number of Serial Numbers where the Data Value is True and the ParameterChildName = SigPod_AirTest_1_Status.Test_Passed and I want to only count the Serial Numbers for the first Entrytimestamp as there can be multiple.

I understand I can count the distinct Serial numbers using DataValue and ParameterChildname, but I need to inlude only the first instance of each EntryTimestamp.

I hope you can help

Al

[rustyfishbones]

I think this maybe it

=Count({<DataValue = {"True"},ParameterChildName = {"SigPod_AirTest_1_Status.Test_Passed"}>} Aggr(FirstSortedValue(Distinct [Serial Number], EntryTimestamp), [Serial Number]))

but again, I need to double check my results.

Thanks for your help

[sunny_talwar]

Sorry, I might be repeating myself, but do you want the value of serial number or the count?

[rustyfishbones]

The Count of the Serial Numbers.