Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II

multiple counts in a single field

I have table like these..

E.ID, E.Name, E.Team

1, hari, HR

2, Narsi, SALES

3, Teaj, HR

4, Kesav, HR

5, Venkat, IT

6, Subbu, IT

7, Lokesh, IT

8, Ktr, IT

9, Naresh, SALES

10, Suji, ACCOUNT ;

count of employee by E.Team

16 Replies
vvvvvvizard
Partner - Specialist

=Count( Distinct E.Team)

ogautier62
Specialist II

Hi,

maybe :

count(E.ID) as EmpTeam resident xxxxx group by E.Team

regards

Kohli
Creator II
Author

I want output like

HR -- 3

IT-- 4

SALES--2

ACCOUNT-1

ogautier62
Specialist II

that's what it does

you have your count in field EmpTeam

DavidŠtorek
Creator III

Hi,

do it as following (if you want to have new table)

Emp_per_team:

Load

E.Team,

count(E.ID) as "Employee Count"

resident <your table>

group by E.Team;


Hope it helps

Kohli
Creator II
Author

There is any chance with the help of FLAGS?

DavidŠtorek
Creator III

How do you mean?

vvvvvvizard
Partner - Specialist

Attached is the solution

kkkumar82
Specialist III

which visualization you want to show your data , is there any specific UI share with us,

if it is a text object you want to do it, then you can use

=Concat(Distinct E.Team &'--' & Aggr( NoDistinct Count(E.ID),E.Team),chr(10))