expression to give quarterly chart and ignoring all date parameters isn't working

gjbankos1 — Tue, 30 Apr 2019 17:22:23 GMT

Hello all. First post, so please forgive my ignorance...

I am trying to put together a quarterly chart that shows the average open warranty days that ignores any date filters applied. When I put this formula in, it doesn't ignore my date filters that I put in here to ignore. If I take the top part of the equation (before the '/'), it works. The bottom part after the '/' does not. The formula itself is coming back with the right numbers. I just can't get it to ignore any date filters

I'm not sure what to do here. Any help would be greatly appreciated and I thank you for your efforts.

Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Avg({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0,Max({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthAgingDays)),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))
/
Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Count({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
DISTINCT Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=,[CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0, Emp_Name),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))

Re: expression to give quarterly chart and ignoring all date parameters isn't working

gjbankos1 — Wed, 01 May 2019 17:27:20 GMT

bump

topic expression to give quarterly chart and ignoring all date parameters isn't working in App Development

expression to give quarterly chart and ignoring all date parameters isn't working

Re: expression to give quarterly chart and ignoring all date parameters isn't working