count on mode function

[rbecher]

Hi,

I'm trying to count the occurrence of the most frequent values in a diagram like this:

count( {$ < Muster = {"=mode(Muster)"} >} Muster )

but the result is wrong. How is the right expression?

- Ralf

[rbecher]

Hi Miguel,

this is a interesting approach with inputfield. In my case it would makes no sense because the mode is changing from selection and nobody would input that data.

I had also some thoughts about to calculate the mode in the script and then having the result in another table for comparison. But this also would be no dynamically solution...

- Ralf

[#3]

Hi Ralf,

I don't understand, why did you say "nobody would input that data"?, because, the data in the input field are calculated trough a macro and it will be always calculated after triggers like open document, changing selection, etc, so, nobody have to input nothing, all is always dinamic.

I made some tests after send the "solution" changing values and it always works.

Sorry, I assumed this would help.

Best regards.

[rbecher]

Hi Miguel,

sorry I got it wrong in the first place. I have to go more deeper into the example. But I'm concerned about large datasets with macro execution...

- Ralf

[#5]

Hi Ralf,

I don't know what is the penality for large datasets (maybe you could try and share the result with us jajaja) but I don't have any more ideas for solving your problem.

good luck.

Best regards.

[rbecher]

I really wonder wha this is an issue because these values are available in listboxes!

- Ralf