SELECT ts arraySumarraySlicetotal 1 i as total_numFROM SELECT groupArraymin_Ds as t groupArrayapp_count as total from SELECT min_Ds countdistinct AppIdentifier as app_co

您可以使用时间序列填充（time series filling），将没有数据的日期填充为0，以使曲线看起来连续。例如，您可以使用以下查询来填充每天的数据：

SELECT date, ifNull(total_num, 0) as total_num FROM ( SELECT toDate(ts) as date, arraySum(arraySlice(total, 1, i)) as total_num FROM ( SELECT groupArray(min_Ds) as t, groupArray(app_count) as total from ( SELECT min_Ds, count(distinct AppIdentifier) as app_count FROM ( select AppIdentifier, min(Ds) as min_Ds from log_iMonkey_iOS_overview GROUP BY AppIdentifier ) GROUP BY min_Ds order by min_Ds ) ) ARRAY JOIN ( SELECT toDate(DATE) as ts FROM system.calendar WHERE DATE >= toDate(#accumulated_access_services.start#) AND DATE <= toDate(#accumulated_access_services.end#) ) as ts arrayEnumerate(total) as i where ts >= toDate(#accumulated_access_services.start#) ) ALL INNER JOIN ( SELECT toDate(DATE) as date FROM system.calendar WHERE DATE >= toDate(#accumulated_access_services.start#) AND DATE <= toDate(#accumulated_access_services.end#) ) as dates ON date = dates.date ) ORDER BY date