How to calculate in a textbox the number of occurences of a minimum? value

[andreas_koehler]

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?

[swuehl · Accepted solution]

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_koehler]

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.