Hi, I need a report, ideally a graph which shows the age of assets as a percentage of the total i.e. <1 year, 1-2 years, 2-3 years 3-4 years, 4-5 years, > 5 years.

example data
Asset Delivery Date


Asset 1 01/01/2007
Asset 2 01/02/2007
Asset 3 10/10/2004

I would be very grateful if anyone can help me get started thanks.

Use a query to build your aging

A simple example would be

if (date() -[age] <= 365.25,1, _
if (date() -[age] <= 365.25*2,2, _
if (date() -[age] <= 365.25*3,3, _
etc for possible years
if (date() -[age] <= 365.25*i,i)

i is the last numerical agen in years

Another is with the query columns being:
[Name]
[Age]
[1 year]: iif(date()-[age] <= 365.25,1,"")
[2 year]: iif(date()-[age] <= 365.25*1 and date()-[age] <= 365.25*2,2,"")
[3 year]: iif(date()-[age] <= 365.25*2 and date()-[age] <= 365.25*3,2,"")
[4 year]: iif(date()-[age] <= 365.25*3 and date()-[age] <= 365.25*4,3,”“)
[5 year]: iif(date()-[age] <= 365.25*4 and date()-[age] <= 365.25*5,4,”“)
[6 year]: iif(date()-[age] <= 365.25*5 and date()-[age] <= 365.25*6,5,”“)
[7 year]: iif(date()-[age] <= 365.25*6 and date()-[age] <= 365.25*7,6,”“)

Adjust the formulae to meet your particular requirement.