how to count value min/max/list

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    11 years ago

    Refer to examples: http://cfdbplugin.com/?page_id=1167

    But use CountField instead of MaxField

    Thread Starter fm43100

    (@fm43100)

    11 years ago

    i try

    [cfdb-table form=”myform” trans=”CountField(quotation,quotation)”]

    output is only one colum with count of field quotation
    5
    7
    3
    2
    10
    I would like to see besides the count value
    es
    $ 10 | 5
    $ 20 | 7
    $ 50 | 3
    $ 100 | 2
    $ 200 | 10

    I have trouble even finding the max of that list trying with
    [CFDB-table form = “Membership fee” trans = “CountMax (CountField (share, share))”]

    result anything

    Plugin Author Michael Simpson

    (@msimpson)

    11 years ago

    I see it doesn’t seem to work right when using the same field.

    Try this as a work-around:

    [cfdb-table form="myform" trans="count=concat(quotation)&&CountField(count,quotation)" orderby="count DESC"]

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘how to count value min/max/list’ is closed to new replies.