multiple counts in a single field

[Kohli]

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

[vvvvvvizard]

=Count( Distinct E.Team)

[ogautier62]

Hi,

maybe :

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

regards

[Kohli]

I want output like

HR -- 3

IT-- 4

SALES--2

ACCOUNT-1

[ogautier62]

that's what it does

you have your count in field EmpTeam

[DavidŠtorek]

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]

There is any chance with the help of FLAGS?

[DavidŠtorek]

How do you mean?

[vvvvvvizard]

Attached is the solution

[kkkumar82]

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))