Forum Discussion

Mjurado's avatar
Mjurado
New Member
6 years ago
Solved

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

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 01version 1.0
username 02

version 1.0

username 03version 1.1
username 01

version 1.1

username 02

version 1.2

 

Desired output example should be (pie chart?) 

Compliance data

 

username 01version 1.1
username 02version 1.2
username 03version 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.

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    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's avatar
      Mjurado
      New Member
      6 years ago

      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!