not repeating employee no

[narender123]

Hi all,

I want to count :

like if a employee no (10) entered in jan then our count is 1.

Same employee no (10) entered in feb then the count remains 1.

If a employee no (11) present in feb but not in jan then count in feb 2  means 1 for jan(employee no 10 ) + 1 for feb (employee no 11 ) --------up to dec .

So a employee count remains same if he is repeating in more than 1 month.

I want this result in monthly basis.

Month     employee count

jan                    1

feb                     2         

march                 7

-

-

dec                  68

I used: count({<employee_status='p'>}distinct employee_no)

its showing wrong result as distinct work as monthly basis distinction for employee no but i want to check distinct yearly of employee no for monthly dimention.    

Thanks

[#2]

Can u paste your app?

[narender123]

No i am working directly on server.

Its not possible.

Do u have any idea to sort out this?

Thanks,

[avinashelite]

try like this:

Aggr(count({<employee_status='p'>}distinct employee_no),Month)

[narender123]

Hi Avinash,

Its already giving distinct against month .but i want distinct against year but showing monthwise dimention.

Thanks

[avinashelite]

then you need to have Year as the dimension as well otherwise it won't give correct result and it will be contradictory

too. Add Year as the dimension and try like this

Aggr(count({<employee_status='p'>}distinct employee_no),Month,Year)

[vikasmahajan]

pfa

vikas