12 Replies Latest reply: Jun 14, 2016 4:46 PM by Alan Farrell RSS

    Count Distinct numbers using FirstSortedValue

    Alan Farrell

      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