AEM Assets provides an enterprise level reporting framework that scales for large repositories through an intuitive user experience.
The following formulas are used in the video to generate the Assets by Size chart in Microsoft Excel.
=IF(RIGHT(D2,2)="KB",
LEFT(D2,(LEN(D2)-2))*1024,
IF(RIGHT(D2,2)="MB",
LEFT(D2,(LEN(D2)-2))*1024*1024,
IF(RIGHT(D2,2)="GB",
LEFT(D2,(LEN(D2)-2))*1024*1024*1024,
IF(RIGHT(D2,2)="TB",
LEFT(D2,(LEN(D2)-2))*1024*1024*1024*1024, 0))))
=COUNTIFS(E2:E1000,"< 200000")
=COUNTIFS(E2:E1000,">= 200000", E2:E1000,"<= 500000")
=COUNTIFS(E2:E1000,"> 500000")
Download All Assets Excel File with Chart