topic Re: DataPower Extensions metric : how to turn last response time to a response time graph in Dashboarding

DataPower Extensions metric : how to turn last response time to a response time graph

leeb — Tue, 09 Dec 2025 12:05:23 GMT

The DataPower extension provides for each webservice a "Last Response Time" metric. Rather than a long graph with the same response time line in the case there is no response in a timeframe, I wanted to turn this into a positive response time graph instead.

I managed to get as far as this in DQL, where I am getting a graph effectively of the delta in response time between the last response and the next one.. Is it possible to graph based off last response time, but calculate based off of response time delta?

Attached is a screenshot of the "lastResponseTime" metric and the delta graph the below DQL provides

I would like to actually graph the response time if it is changed but zero if it is unchanged (ie no request in that time interval)

DQL code for tile below :

timeseries lastResponseTime = max(IBM.DataPower.WebService.lastResponseTime), by: { `dt.entity.datapower:webservice`, `dt.entity.datapower:instance` }
| fieldsAdd array(lastResponseTime),entityName(`dt.entity.datapower:webservice`), entityName(`dt.entity.datapower:instance`), arrayDelta(lastResponseTime)
| sort (lastResponseTime) desc
| limit 20

When I look at the visualization tab i chose the lastResponseTime I get continuous lines for unchanged data, if I chose the arrayDelta one i am getting effectively the delta between this response time and the last one which is not the same as the actual response time.

Wasnt sure if this was a DQL question or a dashboard question pertaining to visualization options so posted here.

Re: DataPower Extensions metric : how to turn last response time to a response time graph

Anderson-Luna — Wed, 10 Dec 2025 02:30:11 GMT

Hi leeb,
to get a “positive-only” graph (show the actual last response time when there were requests, otherwise 0), use the request counter from the DataPower extension as a mask and apply element‑wise logic on the arrays returned by timeseries, I came up with the following dql:

timeseries { lastResponseTime = max(IBM.DataPower.WebService.lastResponseTime), requests = sum(IBM.DataPower.WebService.totalRequests.count) }, by: { `dt.entity.datapower:webservice`, `dt.entity.datapower:instance` }, interval: 1m | fieldsAdd activeResponseTime = if(requests[] > 0, lastResponseTime[], else: 0) | fieldsKeep `dt.entity.datapower:webservice`, `dt.entity.datapower:instance`, activeResponseTime | sort (arrayAvg(activeResponseTime)) desc | limit 20

In the visualization, select activeResponseTime as the series to plot.
This shows the actual response time value only in intervals that had any requests; otherwise it’s zero.
Avoids the flat line effect and the limitations of arrayDelta (which only shows changes, not actual values).
The request counter and lastResponseTime are provided by the DataPower extension and share the same entity dimensions, so they align naturally in a single timeseries call.

Let me know if it helps you!
Best,
Anderson

Re: DataPower Extensions metric : how to turn last response time to a response time graph

leeb — Mon, 09 Mar 2026 11:28:22 GMT

I got caught on a mass migration and missed this reply.. when i try it i get No records all the while i have the requests= in the timeseries part. Playing with it, I get the logic and it is what I was looking for, but cannot get anything except "no records".
If i comment out anything related to totalRequests.count the lastResponseTime part works fine. When i leave it as is i get an "i" next to the 0 Records that says "Classic entity functions are deprecated. Please use smartscape functions instead"
I even stripped it down to just the Requests count like this and got no results
timeseries {
requests = sum(IBM.DataPower.WebService.totalRequests.count)
}

with or without the by: clause