Forum Discussion

Toppler's avatar
Toppler
Helper I
3 years ago

frequency

Hello all,
I have the following sample order id

Order
a
b
c
d
d
d
e
e

how can the absolute frequency be represented in the following target form?

frequentnumber
13
21
3

1

Thanks four your help. 

Greetings

Tobias 

3 Replies

  • Arul's avatar
    Arul
    Super User

    Toppler ,

    sorry it was not clear. Could you explain bit more in detail?

    Thanks,

    Arul

  • sure. 

    i have orders that occur more often in my query. in the following list i can see the frequency of the individual orders.

    now i would like to know how many orders occur once, twice, three times and so on?

     

    it will look something like this. i cannot currently display this with my data.