Create search with percent of total

[jfeitosa_real]

Hi all,
Please help me!

How to create a search with the percentage of desktops with outdated antivirus. Since events are results of a query using DB_Connect in a view, already ready of a lansweeper application. are different views but with the same AssetName field.
Doubt is how to correlate the Assets total of a view with the Asset amount of another view and show in percentage.

Thanks in advance.

James

[cmerriman]

Can you possibly share some sample data and final expected output? are you using one dbxquery to bring in everything or are you trying to join AssetName together with multiple dbxqueries and then create a percentage?