Hello, good morning! Could you help me? I'm trying...
# gd-beginnerst
Tomas Lima
03/31/2025, 11:48 AMHello, good morning! Could you help me? I'm trying to create a weighted average due date metric and I'm struggling.
Weighted average due date is a metric that considers both the value and the maturity date.
j
Julius Kos
03/31/2025, 1:45 PMHi Tomas,
First of call, could you please confirm if we are talking about GoodData Platform or Gooddata Cloud in this case?
t
Tomas Lima
03/31/2025, 2:03 PMI would be talking about this one in the image below, I don't know what they call it, whether it's GoodData Platform or GoodData Cloud
j
Julius Kos
03/31/2025, 3:56 PMHi Tomas, we support Running Total function which might help you here. Can you please double-check?
https://university.gooddata.com/tutorials/creating-metrics/running-total-function-in-gooddata-platform-sum-vs-runsum/
Julius Kos
03/31/2025, 4:30 PMHm but I understand you are looking for a specific Metric. Please note that an arithmetic with Dates is possible on GoodData Platform. You could do for example something like this:
SELECT SUM(Amount * DayOfMonth) / SUM(Amount)
DayOfMonth would be considered as values (1-31) and the MAQL would work with it as it was a number.