aggregation of cummilative metrics based on time and label

[SrinidhiK22]

I have a counter metric, custom_api_requests, with attributes endpoint (e.g., endpoint1, endpoint2) and region (e.g., east, west, south). When I scrape this metric every 10 seconds using the Prometheus receiver, I get 6 data points every 10 seconds. Over a 30-second period, this results in 18 data points.

Goal:
I want to aggregate these 18 data points into two metrics (one for each endpoint), each with a single timestamp (e.g., at the 30-second mark) and aggregated values based on labelset.

Attempted Solutions:

1. batch (timeout 30s) + metricstransform
   This gives 6 metrics for 30s ( 2metrics for 10s as they dont have same timestamp)
2. batch+ transform/truncateTime+ metricstransform
   This gives 6 metrics for 30s (all having 30s timestamp but aggregated like before)

Can someone help which set of processors can be used.
i have used truncateTime from here : https://github.com/open-telemetry/opentelemetry-collector-contrib/issues/4968 but realised that config works for delta metrics. So any solution for cumilative metrics?