Firstsorted Value

[fheidenstecker]

Hi there,

i have a question regarding firstsortedvalue, which is driving me nuts

I prepared an example: I have 2 different Values and an Id. I want to count the Event with the lowest Index. But whatever i try, it always shows me both values

My exprected Result is:

Header 1	Header 2
Value	Count
Test1	2

Please see attached file.

This is just some sample data i created, cause i can't share my real data. The real data is a list of events for each date. I want to count for each day what event occured first 😉

Thanks,

Fabian

[sunny_talwar · Accepted solution]

Try this

=Count(Aggr(If(Value = FirstSortedValue(TOTAL <Day> Value,ID), 1), Day, Value))

[fheidenstecker]

Wow, thanks for the quick hint!

It works, and also for my real life Data!

Need some time to think about the nested use of if and aggr 🙂

Great!