How to use AQL in Assets dashboard to get advanced reporting

[Mina Sultan]

We currently have the following object types in Assets (Cloud version) :

1. PCs → linked to the Users object type.

2. Users → linked to the Departments object type.

3. Departments → linked back to the Users object type.

Our goal is to create an Assets dashboard that displays all PCs belonging to a selected Department.

From what I can see, the Assets dashboard does not provide a widget that allows the use of AQL to filter objects across these relationships.

Is there a way to achieve this within the Assets dashboard? If not, what is the recommended approach for building a dashboard that shows all PCs associated with a specific department?

Any guidance or best practices would be appreciated.

[Gabriela - LeanZero]

Hi @Mina Sultan, there's no AQL field anywhere in the chart builder. A chart is a metric, a group-by, an optional segment and up to five filters, and all of those work on attributes of the object type you are charting. Department sits two references away from PCs, so nothing in that config reaches it.

Atlassian's own hardware example builds the chart you're describing, "Usage of assets by department", by grouping Laptop and Phone on a Department attribute held on the hardware object itself. Copy that shape. Carry Department on the PC type, populate it in the import, then group the chart on it.

For the list itself AQL does traverse. Roughly objectType = PCs AND "User"."Department".Name = "Finance", where the left of each dot has to be the reference attribute's own label on that type. Atlassian's example is "Belongs to Department".Name = HR. A bareword that isn't a real attribute invalidates the query.

https://support.atlassian.com/assets/docs/example-assets-dashboards-and-charts/