Most Frequent Intime and OutTime

[#1]

Hi,

Please find the attached QVW.

I have a field with Most Frequent time and Most Frequent Out time.

Based on the frequency of Most Frequent time/Most Frequent Out time,

If frequency is more then it has to display that.

It is clearly explained in QVW.

Regards,

Keerthi KS

[Clever_Anjos · Accepted solution]

Try =mode(MostFrequentOutTime)

[MK_QSL]

Create List Box using below expression

=Aggr(IF(Rank(COUNT(MostFrequentOutTime))=1,MostFrequentOutTime),MostFrequentOutTime)

[#4]

Thanks Clever. I never used that function

[Clever_Anjos]

It´s a not very well know function, I remember it because "saved my life" once upon a time

[Anonymous]

Thats why we never forget those Function

[#7]

What if Frequency is equal ? MostFrequentOutTime is same

[Clever_Anjos]

When we have the same frequency for 2 or more values, Mode() returns null

[Clever_Anjos]

In this case, which one you want to show?

[#10]

Yea it returns null. What if I need to show atleast one value.