8 Replies Latest reply: Jul 13, 2017 4:17 AM by Antonio Mancini

# Find Count of Customers avilable in all date

Hi Expects,

I need to calculate the no of customers that should available in all selected date. I have attached the sample data. any one can help me to do the task.

Thanks

• ###### Re: Find Count of Customers avilable in all date

Hi,

Try like below

count(distinct Customers)

• ###### Re: Find Count of Customers avilable in all date

Hi Devarasu,

Thanks for you reply, This is not my output, i should count the customers who all available in all dates.

• ###### Re: Find Count of Customers avilable in all date

Can you share your expected output for the given data,.tks

• ###### Re: Find Count of Customers avilable in all date

Hi,

try this in Text Box

=Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

Regards,

Antonio

• ###### Re: Find Count of Customers avilable in all date

hi Antonio,

Thank you so much, yes this is my output. but one more step i have to do,

I have to plot this value in the date.

is it possible??

• ###### Re: Find Count of Customers avilable in all date

I have attached my data,

Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

from above expression i am getting my output

i need to show the result in following way,

by your expression i am getting the result "1" value only at the 1st date  the result "1" should appear in all selected date.

• ###### Re: Find Count of Customers avilable in all date

Hi,

Try this

=Sum(TOTAL Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

Regards,

Antonio

• ###### Re: Find Count of Customers avilable in all date

if i select the following dates

 2-20-2017 2-20-2017 2-23-2017 2-23-2017 3-20-2017 3-20-2017 3-20-2017 3-20-2017 3-15-2017 3-15-2017

my output should be

Because in my data customer "A" is available in all dates

if i select the following dates,

 3-15-2017 6-20-2017

my output should be

Because in my data customer "A" and "B" is available in selected two dates

Thanks