Hi appsheet community,
Iโve an ORDERBY() challenge:
I want to organize my dropdown column [places] according to their popularity. For this purpose, in the table next to the column [places] I created a virtual column [popularity] with a count formula that adds up the number of times that space has been selected.
For the dropdown I wanted to use this formula:
ORDERBY (Brussels [ID], [places]) => dropdown is ordered alphabetically in places.
Is there a way I can arrange [places] via [popularity]?
ORDERBY(Brussels[ID], [popularity], TRUE, [places], FALSE)
That should order it first by popularity descending, then by places alphabetically, ascendingโฆ
@Diogenes_ASBL_VZW This is a useful setup, can you please post your VC Count formula setup? Thx!
Fantastic!
VC Formula: [popularity] =COUNT(SELECT(Registration[ID], [_THISROW].[Places] = [Places]))
Registration: table where user fill in the places of interest. [_THISROW].[Places]: refering to the column places of each row in tabel registration
[Places]: column in table
I hope this helps โฆ Greetings
@Diogenes_ASBL_VZW Glad it worked out!
@Grant_Stead In the case you use a dependend dropdown, it seems you canโt use orderby()?
Is this correct?
thx
@Diogenes_ASBL_VZW not sure
For the dependent dropdown you could try to use SORT expression.
Here is a formula that works to order a dependent dropdown column:
=IN([_THIS], Orderby( SELECT(List Lieux[Lieu],[_THISROW].[Sorte Lieu]=[Sorte Lieu]), [Nombre Interventions],True, [Lieu],False ))
Translate
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |