How to Calculate the Mode or Modal Value

[Former Member]

Hello Gurus.

I'm a rookie in BI, somebody would you say me: How to Calculate the Mode or Modal Value in a query BI 3.X or 7? Pleaseeeee.

Thanks.

[Former Member]

Hi,

I am not sure, this is the thing you r looking for:

In query designer >> formula key figure >> Mathematical functions >> "Reminder with whole-number division" (MOD).

Thanks,

Jitender.

[Former Member]

Thanks you, but the mode or modal mode is simply the number which appears most often, for example:

Look at these numbers:

3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29

In order these numbers are:

3, 5, 7, 12, 13, 14, 20, 23, 23, 23, 23, 29, 39, 40, 56

This makes it easy to see which numbers appear the most.

In this case the mode is 23.