seabrig29 asked a question.
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% IncompleteMeasuredCorporate 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%
@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.