-
Re: Set Analysis with Aggr/Rank or Min?
Andrey Khoronenko Jul 27, 2017 4:24 AM (in response to Cassandra Baqir)Hi,
May be like this
=Count({$<DEFECT_STATUS_START_DATE={">=$(=Date(addmonths(monthend(today()),-6),'MM/DD/YYYY'))"}*{"<=$(=Date(addmonths(monthend(today()),0),'MM/DD/YYYY'))"}*
{"=Aggr(Min(DEFECT_STATUS_START_DATE), DEFECT_ID)"}>} distinct DEFECT_ID)
-
Re: Set Analysis with Aggr/Rank or Min?
Sunny Talwar Jul 27, 2017 7:09 AM (in response to Cassandra Baqir)Try this
='Tickets Created (Expecting 736): ' &
Count({$<DEFECT_ID = {"=Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today(),-6) and Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) <= AddMonths(Today(), 0)"}, DEFECT_STATUS={'New'}>} DISTINCT DEFECT_ID)
Gives me 735 because the result is based on Today's date of 7/27/2017... but if you use this
='Tickets Created (Expecting 736): ' &
Count({$<DEFECT_ID = {"=Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today()-1,-6) and Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) <= AddMonths(Today()-1, 0)"}, DEFECT_STATUS={'New'}>} DISTINCT DEFECT_ID)
which is 7/26/2017, it gives 736
-
rolling_count_2_aggr.qvw 5.0 MB
-
Re: Set Analysis with Aggr/Rank or Min?
Cassandra Baqir Jul 27, 2017 10:16 AM (in response to Sunny Talwar )You are amazing!
-