Count people distinct per day

[carlos13]

I want to count the number of different people doing transactions per day.

A person can do different transactions per day, but count me as one.

the total, whether selected years, days or months count a person per day always

thought so, but it didn't work

Aggr( Count( Distinct  ID_PEOPLE)) , Day)

Thanks in advance,

[Anonymous]

Carlos,

It looks like you need another function around your Aggr() function.  Do you want the average number of distinct people per day?  Or are you just trying to look at the distinct number of people per day?

If you want something like the average or overall total, you need something like:

Avg( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

or

Sum( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

If you just want to see the distinct count per day, then create a new straight table chart.  Then, select Day as your dimension and use Count(DISTINCT ID_PEOPLE) as your expression.

I hope this helps.  Let me know if I'm misunderstanding what you want.

-Jeff

[aveeeeeee7en]

Hi Chris

Please see the Attached Sample Qvw.

Hope it works.

Regards

Aviral Nag

[Anonymous]

Hi Carlos,

As per your requirement count the number of different people doing transactions per day.

with a person doing different transactions per day counted as one,below expression works

=Sum( Aggr( Count(DISTINCT ID_PEOPLE), Day) )

[#5]

hi Carlos,

I think you want to avoid the selection of year, month and date. then you have to use the set analysis like this.

Aggr( {$<YEAR=,MONTH=,Day=>} ( Distinct  ID_PEOPLE))