calculate the age of debt, fifo payment

[#1]

Hello, could someone give me an advice, how to solve a problem of showikg companies debts in order to their age?

Client has a huge amount of partners,  lots of transactions. He wants to see debts of partners, dew to their age: wich debts are less then month, which 1-3 months, which 3-6 months... (the best- to be able to choose the limits in the app by himself....) He want to see it in different lines or colours of bars..

the payment scheme is FIFO: the new transfer goes to repay the oldest debt... So there are ... emm......steps...=)

I've tried to make different loops, but didn't succeed...i guess it best to do the calculations in the script, because there are few thousands of partners..

Could you kindly look at the app an advice how to solve the problem?

how should the age be calculated:

[JonnyPoole]

You can use the class() function in a calculated dimension and it will bucket the days into ranges (0-30 , 31-60 etc..)

I opened your QVW but couldn't figure out which is the calculation to determine days.