Group two levels

[mr_anh_ngoc]

What I’m trying to do

Hello,
I want to group by two levels.

refering to this workaround:

Group By on two levels

What if I wanted the number of files not in a separate column, but behind the ‘name’ of the website between brackets? Network Website A 1 (1) _ 2 (1) B 3 (2) I’ve tried to compile it as rows.Web + "(" + map(rows, (r) => length(r.rows)) + ")" AS Website but that doesn’t work… I then get a sequence of Websites and a sequence of numbers… If I’d know how the data is fetched and processed, perhaps I could figure it out myself… But unfortunately I can’t seem to find the inner worki…

I have my problems, because the sample above got only 2 NETWORK values: A and B.
But what If I have besides A and B more entries …?

Things I have tried

so I set some files:

file_1
Network:: A
Website:: 2

file_2
Network:: A
Website:: 4

file_3
Network:: A
Website:: 4

file_4
Network:: B
Website:: 2

file_5
Network:: B
Website:: 3

file_6
Network:: C
Website:: 1

file_7
Network:: C
Website:: 2

file_8
Network:: D
Website:: 1

file_9
Network:: D
Website:: 3

and by using the DV query from above it shows:

but which, according to my understanding, should look like this:

so how would it have to be changed to get these values?