Need explication for group by

Does i can group by multiple field?

my database (53000 records)
image

i want to "group by" country, year, month (colums 6,3,2 of the database)

no problem for only country:
image

i like something like that but it's not working:
image

just say yes or no, don't invest time in this, i have already a workaround but i want to be sure the response is no...

yes, it's a ring (a HOF)!

i can't figure how it's working.

what i should put here to group by columns 6,3,2
image

Help !

Bump! someone can help me plz !

Use this:

[scratchblocks]
(map ((item (list [6] [3] [2]@addInput::list) of ⌸::list)@addInput::ring grey) over (database)::list)
[/scratchblocks]

EDIT: realized this wasn't what you were looking for.

@bh can you help me plz

jens say:

My question is:

thank's in advance !

It seems that "group by" needs a "simple" key.
Simple as List Tutorial script pic (1)
but to avoid some inconsistency with "join",
List Tutorial script pic (2)
List Tutorial script pic (3)

Thank's, that's already my workaround... it's working, but i don't like the output :
image
(watch the 1st column: json in this case...)

So, i created a new block:
image
i can expand the "column number" to add more columns

Here's the result:
image

you can try it in this project: (in the sprite my blocks)

Project not shared

Thank's: Done !

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.