0

Hey ! Do you want another tricky question ??? Again concerning sorting…

One thing that is great in ninox is the way we can group records…

Another thing that is great and super easy is to count the number of records in each group…

But… now… i would like my groups to be sorted by the number of records they have in them ???

Any genious with a good method ??? Am i missing something simple ?

Thanks all

15 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    You are! 😎 This requires another Formula field and this is the code I used...

     

    let t := this;
    count(select YourTable where Choice = t.Choice)

    • Laurent
    • 5 yrs ago
    • Reported - view

    Well, well, well… this is not what i was waiting for… i wanted to re-sort the tabular mode… you know, the simple screen…

    The problem with the count method is "the time it takes"… even with the "do as server" trick…

    Right now i have 29249 records and about 150 choices… i'm a little afraid of lauching that count method… i'm going to have the spinning wheel for a while… and i even might lose it…

    • Sean
    • 5 yrs ago
    • Reported - view

    I guess I'm not sure what you mean by "tablular mode" unless you are referring to the table view. If you are referring to the table view, that solution works. You just click on the Formula field column header and choose your sort preference.

     

    I admit I do most of my work locally with the Mac app so I don't experience the lags that cloud users experience. Having said that, I find that making even a small change on the cloud version is much slower than working locally.

    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Laurent... How "dynamic" do the rankings have to be?  If 100% .. then per the other thread... You could create a "choice table" .. and add a function to that table for the sort..  If daily, weekly (etc) ..   You could create code behind a button that populates the record count.  

    I have  a table with over 33,000 rows.. but only about 18 variation groups.. it is World Health Organization (WHO) standard deviation data... not your 180.... and a count button processed them in about 3 seconds. 

    • Laurent
    • 5 yrs ago
    • Reported - view

    oh boy… i just had finished answering sean and i was kicked of !!! i hate that ! i lost all my content…

    • Laurent
    • 5 yrs ago
    • Reported - view

    i'll come back a little later and answer both sean and mconneen ! sorry folks !

    • Laurent
    • 5 yrs ago
    • Reported - view

    @sean

    Yes tabular mode = table view, sorry...

    i might not be very clear, let me take an example

    let's say we have 2 fields

    field A or column A is a ref.

    field B or column B is a text

    if I click on column A header, i can select "total"

    if i click on column B header, i can select "group"

    now if I close all the sections I can easily find out how many (looking in A) records have the B content... what I would like is to sort those A results...

    for example, i would say my top B content is abc, followed by def, then it appears to be ghi, and so on...

    grouping 30000 records by 150 items is one second !

    ninox is soooooo fast for grouping and so slow for counting... i'm sure some codes aren't optimized there...

     

    yes i'm on cloud version right now

    i tried the count method and i stopped after 15 min - no results !

    i also tried the "do as server..." : not better there...

    i also have a mac app, but I still fetch my data on the cloud...

    never tried much ninox locally with the mac app...

    i guess speed then depends on the machine and the ssd inside it...

    • Laurent
    • 5 yrs ago
    • Reported - view

    @mconneen

    3 seconds !!! Do you have a Mac Pro ???

    18 is not 150 but that sure is fast !

    maybe the count is faster with integers ?

    my "B" column is text...

    maybe I'll have to test 100% locally, I might be very surprised, I have a HD but 20GO of RAM...

    • Laurent
    • 5 yrs ago
    • Reported - view

    By the way, I don't know if ninox app uses that extra ram ???

    • Sean
    • 5 yrs ago
    • Reported - view

    Laurent, I agree with Mconneen about attaching the code to a button if you update that information infrequently.

    • Laurent
    • 5 yrs ago
    • Reported - view

    you know what ? I finally got what I wanted in a second !!!
    i printed in html, copy, went to my favorite easy csv editor app, paste, sort with ECE, and done !!!
    sometimes we have to remember to be clever… only the result counts !
    funny, I used the word "count"…
    of course I will search for the Ninox solution… but right now I have no time !!

    • Laurent
    • 5 yrs ago
    • Reported - view

    btw did you know grouping was case sensitive ? can you confirm ?

    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Laurent, 

    Yes.. Ninox inconsistently (at least seemingly so) case sensitive.    Find's, like ... are NOT case sensitive.. groupings where clauses appear to be.. 

    • Birger_H
    • 5 yrs ago
    • Reported - view

    I have to check on this. If in doubt use these functions:
    –––
    lower(String)

    upper(String)
    –––

    Birger

    • Laurent
    • 5 yrs ago
    • Reported - view

    thanks birger, i forgot to use those…

Content aside

  • 5 yrs agoLast active
  • 15Replies
  • 3239Views