Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Then method 1 & Anil suggestion should work. let us know if u have any issue. tks
May be Count(DISTINCT Date)
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];
Dear Devarasu,
I am doing it with front end.
Then method 1 & Anil suggestion should work. let us know if u have any issue. tks