Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate in a textbox the number of occurences of the minimum numerical value of a field (#Data) over a period of time (%Timestamp).I assumed that I need to count all the occurences when Min(Aggr(avg(#Data, %Timestamp)) equals Min(#Data). But how do I actually do this?
Andreas, it's not exactely clear in which context you are evaluating this expression.
Maybe something like this?
=Count({<[#Data] = {'$(=Min([#Data]))'}>} [#Data])
I think it would be helpful if you post some sample records and your expected result.
Andreas, it's not exactely clear in which context you are evaluating this expression.
Maybe something like this?
=Count({<[#Data] = {'$(=Min([#Data]))'}>} [#Data])
I think it would be helpful if you post some sample records and your expected result.
Swuehl,
this worked perfectly. My apologies for not adding some samples.
Thanks to your answer I understood that it was not relevant for this calculation in what context the values of the field [#Data] were selected (here it was the selection of a time period).
It is only relevant to count all the values of the selected values that equal Min([#Data]) and this is best done with a set analysis. Nice.