topic Re: Show KPI calculation monthly in App Development

Show KPI calculation monthly

krmvacar — Thu, 07 Dec 2023 08:23:47 GMT

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 — Thu, 07 Dec 2023 08:59:21 GMT

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 — Thu, 07 Dec 2023 17:38:35 GMT

Thank you for reply.

I tried but it didn't work.