Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=Count(Aggr(If(Value = FirstSortedValue(TOTAL <Day> Value,ID), 1), Day, Value))
Try this
=Count(Aggr(If(Value = FirstSortedValue(TOTAL <Day> Value,ID), 1), Day, Value))
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!