Count on Set analysis expression with dates as if condition

[Anonymous]

Find the below table as sample:

I have this set analysis expression " Count({<MachDatekey = {"=design_accept = 3"}>} DISTINCT MachDatekey) "to count distinct MachdateKey if design_accept=3 for all rows of that MachDateKey.

Now I have included Date field in the input data as I have another version of data for the same MachDateKey.

How can I include the Datefield in the above set analysis expression for getting the same result by considering 8/7/2018 as minimum date and 8/14/2018 as maximum date ?

[michaelsikora]

May be try this:

Count(DISTINCT {<MachDatekey = {"=design_accept = 3"}, DateField ={">=$(=today()-7)) <=$(=today()-1))"}

>}  MachDatekey)

If you want you can replace today()-7 with a specific date '8/7/2018' depending on your format for date.

[jonathandienst]

Doesn't the simple expressions work?

Count({<design_accept = {3}>} DISTINCT MachDatekey)

Use this in a table/chart with Date as a dimension.

[Anonymous]

I can't because that will become the third dimension.

[Anonymous]

I got the expression.

Thanks all