@davidrodriguez maybe i found a workaround to do that!
In my use case, I need count logs by a message pattern and do a cummulative summarize to have a linear growth chart...
To do that I change my chart to "code chart" and implement the query using "@dynatrace-sdk" + response manipulation
See this example, and check if helps you
/*
* This function will run in the DYNATRACE JavaScript runtime.
* For information visit https://dt-url.net/functions-help
*/
import { queryExecutionClient } from '@dynatrace-sdk/client-query';
export default async function () {
const env = $Environment;
const from = $dt_timeframe_from;
const to = $dt_timeframe_to;
const timeout = 60;
const query = `
fetch logs, from:"${from}", to:"${to}"
| filter dt.host_group.id == "${env}"
| parse content, "JSON:contentjson"
| filter contains(contentjson[message], "TradeCreationRequested") or
contains(contentjson[messageTemplate], "Trade created") or
| summarize Requested = countIf(contains(contentjson[message], "TradeCreationRequested")),
Created = countIf(contains(contentjson[messageTemplate], "Trade created")),
by: delta = bin(timestamp,10m)
| sort delta desc
`;
const response = await queryExecutionClient.queryExecute({ body: { query, requestTimeoutMilliseconds: timeout * 1000, fetchTimeoutSeconds: timeout } });
response.logs = null;
for (let i = 0; i < response.result.records.length; i++)
{
response.result.records[i].Requested = response.result.records.filter((_, index) => index >= i).reduce((a, b) => a + (b.Requested * 1), 0);
response.result.records[i].Created = response.result.records.filter((_, index) => index >= i).reduce((a, b) => a + (b.Created * 1), 0);
}
return response.result
}
