Hi,

Try this,

create a calculated filed as shown

For the first questionc

distinct customer id:

{ FIXED [Order Date]:COUNTD([Customer ID])}

Use this filed and filter for a date to show the Sum of distinct customer id

For the next two questions, you can use a calculated field to filter the values  as shown,

Use the distinct customer id: calculation and filter the date using the below instead of choosing a filler date

distinct customer id which have an issued today:

[Order Date]=TODAY()

OR

[Order Date]={MAX([Order Date])}  (FOR recent date)

Drag this to filter and select TRUE

For the past date you can modify the above calculation as shown

[Order Date]<TODAY()

OR

[Order Date]<{MAX([Order Date])}  (FOR recent date)

You can also make use of parameter to show all of them as per selection

Hope this helps!

If this reply helps, mark it as helpful/correct

Manoj

Hi, Udit

try this

1. Countd(if [your date field] = Date("2019-08-08") then [Customer ID] end)

2. Countd(if [your date field] = Today() then [Customer ID] end)

3. Countd(if [your date field] < Today() then [Customer ID] end)

Let me know if you have question.

ZZ

If you want to pick that given date yourself by a filter then change the first calculation of Zhouyi Zhang to

Countd(if [your date field] = [your date field] then [Customer ID] end)

and use a filter on it. You need to put this one on a seperated worksheet because the datefilter can't be applied to the 2 other calculations.

Hi, Udit

It will depend on how your data looks like, my sample calculation is working for normal case, so if you can provide a sample workbook, it will be easier to say yes/no.

ZZ