
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Count( Distinct E.Team)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
maybe :
count(E.ID) as EmpTeam resident xxxxx group by E.Team
regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I want output like
HR -- 3
IT-- 4
SALES--2
ACCOUNT-1


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
that's what it does
you have your count in field EmpTeam


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is any chance with the help of FLAGS?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How do you mean?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attached is the solution

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))

- « Previous Replies
-
- 1
- 2
- Next Replies »