Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:
Date1 | Date2 | ID | comment |
26/05/2016 | 26/05/2016 | 200 | Test |
27/05/2016 | 27/05/2016 | 300 | Test |
8/8/2016 | 8/8/2016 | 100 | Test |
10/10/2016 | 10/10/2016 | 400 | Test |
10/12/2016 | 10/12/2016 | 500 | Reject |
10/13/2016 | 10/12/2016 | 500 | Reject |
Date1 as a dimension
Expression:Count({<where comment = Test,Date1 greater than (Date2 - 60)>} Distinct ID)
Please help me in writing the above set expression to get the below output:
Output:
Date1 | Date2 | ID | comment |
5/26/2016 | 5/26/2016 | 200 | Test |
5/27/2016 | 5/27/2016 | 300 | Test |
8/8/2016 | 11/8/2016 | 100 | Test |
Assuming that Your dates are properly formatted (i.e not string)
=Count({<comment ={'Test'}, Date1={"=Date1>Date2-60"}>} distinct ID)
Hi,
As per the condition what you are telling you will get all Test cases.
But your output contains 3 cases only.
Is there any other conditions.