https://community.dynatrace.com/t5/DQL/makeTimeSeries-keep-asking-me-to-provide-value-for-optional-time/m-p/301944#M3434 <P>I have created an OpenPipeline and try to manipulate the data to create a TimeSeries for web request count over time and sum for total web requests within a set time period (vary with the time period set in dashboard)</P><P>I have tried to use the following DQL</P><LI-CODE lang="markup">timeseries { sum(webrequest), value.A = avg(webrequest, scalar: true) }, by: { azure.location, duration, server.address, TenantID, Tenant, url.path, k8s.cluster.name, k8s.namespace.name, k8s.workload.name, dt.host_group.id, dt.entity.service } | fieldsAdd dt.entity.service.name = entityName(dt.entity.service) | fieldsAdd Tenant = if (tolong(TenantID) == 1, "Country A") | fieldsAdd Tenant = if (tolong(TenantID) == 2, "Country B", else:Tenant) | fieldsAdd Tenant = if (tolong(TenantID) == 3, "Country C", else:Tenant) | filterOut isNull(Tenant) | makeTimeSeries webrequestcount = count(), by:{ TenantID, Tenant } | fieldsAdd sum_webrequestcount = arraySum(webrequestcount) | sort sum_webrequestcount desc</LI-CODE><P>However, it returns the following error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hillman_0-1784107814961.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/33678iE6EF0F7A31E1FB4C/image-size/medium?v=v2&amp;px=400" role="button" title="Hillman_0-1784107814961.png" alt="Hillman_0-1784107814961.png" /></span></P><P>When I check the data by comment out those 3 makeTimeSeries statments, the data does include timestamp data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hillman_1-1784107942906.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/33679i746266AF8857F0F5/image-size/medium?v=v2&amp;px=400" role="button" title="Hillman_1-1784107942906.png" alt="Hillman_1-1784107942906.png" /></span></P><P>Why does that happen?</P> Thu, 16 Jul 2026 01:50:07 GMT Hillman 2026-07-16T01:50:07Z https://community.dynatrace.com/t5/DQL/makeTimeSeries-keep-asking-me-to-provide-value-for-optional-time/m-p/301944#M3434 <P>I have created an OpenPipeline and try to manipulate the data to create a TimeSeries for web request count over time and sum for total web requests within a set time period (vary with the time period set in dashboard)</P><P>I have tried to use the following DQL</P><LI-CODE lang="markup">timeseries { sum(webrequest), value.A = avg(webrequest, scalar: true) }, by: { azure.location, duration, server.address, TenantID, Tenant, url.path, k8s.cluster.name, k8s.namespace.name, k8s.workload.name, dt.host_group.id, dt.entity.service } | fieldsAdd dt.entity.service.name = entityName(dt.entity.service) | fieldsAdd Tenant = if (tolong(TenantID) == 1, "Country A") | fieldsAdd Tenant = if (tolong(TenantID) == 2, "Country B", else:Tenant) | fieldsAdd Tenant = if (tolong(TenantID) == 3, "Country C", else:Tenant) | filterOut isNull(Tenant) | makeTimeSeries webrequestcount = count(), by:{ TenantID, Tenant } | fieldsAdd sum_webrequestcount = arraySum(webrequestcount) | sort sum_webrequestcount desc</LI-CODE><P>However, it returns the following error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hillman_0-1784107814961.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/33678iE6EF0F7A31E1FB4C/image-size/medium?v=v2&amp;px=400" role="button" title="Hillman_0-1784107814961.png" alt="Hillman_0-1784107814961.png" /></span></P><P>When I check the data by comment out those 3 makeTimeSeries statments, the data does include timestamp data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hillman_1-1784107942906.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/33679i746266AF8857F0F5/image-size/medium?v=v2&amp;px=400" role="button" title="Hillman_1-1784107942906.png" alt="Hillman_1-1784107942906.png" /></span></P><P>Why does that happen?</P> Thu, 16 Jul 2026 01:50:07 GMT https://community.dynatrace.com/t5/DQL/makeTimeSeries-keep-asking-me-to-provide-value-for-optional-time/m-p/301944#M3434 Hillman 2026-07-16T01:50:07Z