How to get count of records group by a column

Avatar

Avatar
Level 1
kankvats1
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
kankvats1
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
kankvats1
Level 1

09-02-2021

Hi ,

 

Could some one help to use the aggregate function count to get number of rows based on one particular column. For e.g something like below corresponding to sql.

 

select count(1),testcolumn from testtable group by testcolumn .

so i can get the records liks as below:

test1 100

test2 200

test3 300

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
gunnark17854189
Level 1

Like

1 like

Total Posts

13 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
gunnark17854189
Level 1

Like

1 like

Total Posts

13 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
gunnark17854189
Level 1

10-02-2021

Bildschirmfoto 2021-02-10 um 14.27.54.png

you can do a query and then click on "group". You also check the box to Advanced parameters

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

171 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

171 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

15-02-2021

Hi @kankvats1,

Were you able to resolve this query with the given solution or do you still need more help here? Do let us know.

Thanks!