Need Help with getting most recent version from a column for compliance

[Mjurado]

Hello, First Post

I have a field that i would like to check for compliance of the latest version for an individual, the column contains applications version numbers, and another unique columns that is a users column.

example:

username 01	version 1.0
username 02	version 1.0
username 03	version 1.1
username 01	version 1.1
username 02	version 1.2

Desired output example should be (pie chart?) 

Compliance data

username 01	version 1.1
username 02	version 1.2
username 03	version 1.1

the problem i am running into, is that when i filter this data by "count of username by version" im getting the unique username in both columns, vs latest version, i would like to have the most recent version be the only thing that is calulated for compliance, so that when a user does upgrade from one version to the next, the data doesnt show they have both versions or more .

I hope this makes sense, and appreciate anyone who can decipher my thought process.

[v-alq-msft · Accepted solution]

Hi, @Mjurado 

You can enter into Query Editor, choose your query and go to Transform->Group By, setting like the picture below.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mjurado]

Thank you @v-alq-msft  this did give me the correct information i needed.

To add on to this , is there a way i can place this in a custom column within an established Query?

When i tried the method you provided by "grouping" it made the rest of the Query columns dissapear, in the end i had to duplicate the Query and apply this group then link the Queries together by username.

Before Group by MAX versionbefore action

After MAX version

Is there a way i can insert this information you provided into a column at the end of the original Query instead?

and again Thank you for responding to my question, i really apprecaite the help!