Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Doesn't the simple expressions work?
Count({<design_accept = {3}>} DISTINCT MachDatekey)
Use this in a table/chart with Date as a dimension.
I can't because that will become the third dimension.
I got the expression.
Thanks all