cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Calculations in reports

I have a report of devices.

Some fields on this report are completed some are not.  I'd like to. transform this report into a metrics report showing a list fields, such as location, owner, is serial number complete?  as total numbers

such as something like this for my printer data: But this all requires calculated fields.  It be great if I can turn this into a drill down report.  Too complicated for Flexnet?  Hmm?

FieldNot Null/YesNull/NoTotal% Complete% Incomplete
Measured
Corporate structure              20,012          1,054       21,06695.00%5.00%
Specific Location              20,344               722       21,06696.57%3.43%
Floor              19,892          1,174       21,06694.43%5.57%
IP Address              19,997          1,069       21,06694.93%5.07%
Printer Mac Address              19,425          1,641       21,06692.21%7.79%
Service ID              19,613          1,453       21,06693.10%6.90%
Existing # of Trays              18,167          2,899       21,06686.24%13.76%
Data Jack              10,395       10,671       21,06649.34%50.66%
(1) Reply

@seabrig29 - You are correct in that the current Report Builder allows you to create a new list of items, but the ability to group, create calculated fields and sub-totals do not exist.

Your options for creating these types of reports are:

1 - Use Flexera Analytics, powered by IBM Cognos.

2 - Download your report to Excel and use sorting, grouping and sub-totaling within Excel

3 - If you have ITAM Cloud, use the available Rest APIs to extract data and then use a tool such as Power BI or Tableau to read the extracted data and create reports and dashboard

4 - If you have FNMS On-Premises, you can access the database directly and create your own SQL stored procedures and SQL Views within the FNMS database and link a tool such as Power BI or Tableau against the database and the views you have created.