Aging Reports

You can generate reports that show the calculated age of assets or inventories based on a determined date.

The reports will be generated in CSV files that you can either download, or export to Google Sheets or Excel for constant live updates, or use with Power BI or Looker Studio for interactive visualization.

The basic reports will include the barcode or NFC tag values, the name of the assets or inventories, and the age results. You can, however, select other custom fields to be included in the reports too.

You can filter the data returned in the reports by specifying the age condition.

Go to Options > Calculate Aging or Options > Aging Reports from the tables where the calculation reports feature is available.

Generating Visualization Reports

With Power BI

On the reports page, choose the Power BI or Looker Studio option.

In your Power BI application, go to Get Data > Web.

Next, paste the copied URL in the dialog prompt then click on the OK button.

Once Power BI has imported your data, you can generate the visualization reports you want.

To refresh the imported data, in Power BI, in the Power Query Editor, click on the Refresh Preview.

Note – if you see columns with the text “*hidden*” then permission to view the data is required by the user setting up the reports.

With Looker Studio

On the reports page, choose the Power BI or Looker Studio option.

Open a new Google Sheets spreadsheet, then give it a name.

After that, select cell A1 go to the fx section, paste the URL string that you copied then press ENTER on your keyboard.

After a few seconds, your data will be shown on the spreadsheet.

Note – if you see columns with the text “*hidden*” then permission to view the data is required by the user setting up the reports.

Once that’s done, log in to your Looker Studio account.

Click on the Blank Report template.

From the “Add data to report” prompt, select Google Sheets. Follow authentication steps if prompted for them.

You will then be presented with a list of spreadsheets.

Select the one that you imported the data to.

Once Looker Studio has imported your data, you can generate the visualization reports you want.

Exporting Continuously

Using Google Sheets

On the reports page, choose the Export to Google Sheets or Excel option.

In the pop-up modal that then appears, click on the Copy Google Sheets URL button.

Open a new Google Sheets spreadsheet, then give it a name.

After that, select cell A1 go to the fx section, then paste the URL string that you copied then press ENTER on your keyboard.

After a few seconds, your data will be shown on the spreadsheet.

Google Sheets will automatically refresh the data each time it detects a change.

Using Excel

On the reports page, choose the Export to Google Sheets or Excel option.

In the pop-up modal that then appears, click on the Copy Excel URL button.

In your Excel file, go to the Data tab then select From Web.

After that, paste the URL you copied for Excel, click OK, and follow any prompts shown.

In the dialog that appears, click on the Load button.

Your data will then get imported into a workbook.

To refresh the imported data, click on the refresh icon on the right-hand side pane.