我一直试图寻找一个解决方案,但找不到类似的东西。
但我希望它看起来像这样:知道我该怎么做吗?=QUERY('FM - Americas'!A:J,"select E,J where (E >= date '2020-10-01') and (E <= date '2020-11-30') Order By J, E",0)谢谢!
在运行此查询时,我遇到了错误"Divide by zero error encountered“。 (SUM(CASE WHEN EML_DateViewed IS NOT NULL OR EML_DateClicked IS NOT NULL THEN 1 ELSE 0 END)) * 100 / SUM((CASE WHEN EML_Datesent IS NOT NULL THEN 1 ELSE 0 END))