Employee wise counts

[bhuprakash]

Dear all,

I have below data and i want employee wise counts based on date.

Emp Name	Date
A	12/12/2017
A	9/12/2017
B	10/12/2017
C	4/12/2017
C	4/12/2017
C	4/12/2017

so result should be as below -

Emp Name	Counts
A	2
B	1
C	1

Please help me in the same.

[Anil_Babu_Samineni]

May be Count(DISTINCT Date)

[devarasu07]

Hi,

do u wanted to do in front end or back end?

method 1: using front end

Dimension:

Date

Measure:

count(distinct Date)

method 2: back end script

Emp_Count:
LOAD * INLINE [
    Emp Name, Date
    A, 12/12/2017
    A, 9/12/2017
    B, 10/12/2017
    C, 4/12/2017
    C, 4/12/2017
    C, 4/12/2017
];
join
load [Emp Name],
Count(DISTINCT Date) as EMP_Count Resident Emp_Count group by [Emp Name];

[bhuprakash]

Dear Devarasu,

I am doing it with front end.

[devarasu07 · Accepted solution]

Then method 1 & Anil suggestion should work. let us know if u have any issue. tks