Show KPI calculation monthly

[krmvacar]

Hi All, 

I have a KPI and my calculatıon:

(SUM(if(Date<=Today(),DBALANCEUSD))-1686000) / SUM(if(YEAR(Date) > 2020,DBALANCEUSD))

If I select 2023 as the year, I get the following image

I want to get the trend analysis of this calculation on a monthly basis.But it brings me wrong data. Could you help?

Month Dimension: Month(Date)

Year Dimension:Year(Date)

OVERDUE RATIO Measure:(SUM(if(Date<=Today(),DBALANCEUSD))-1686000) / SUM(if(YEAR(Date) > 2020,DBALANCEUSD))

Thank you.

[brunobertels]

Hi 

May be try to aggr your mesure by month and year ? 

aggr(

(SUM(if(Date<=Today(),DBALANCEUSD))-1686000) / SUM(if(YEAR(Date) > 2020,DBALANCEUSD))

, MONTH, YEAR ) 

[krmvacar]

Hi @brunobertels ,

Thank you for reply.

I tried but it didn't work.