Present only the max value

gal_polak — Wed, 21 Nov 2018 12:56:18 GMT

Hi all,

I have a table that present for each question the user answer and the number of attempt he made for this question, see example table:

Quiz Attempt Number	Quiz Question	Answer	User Code
1	- Did the Seller acknowledge how they feel about the change?	true	DE1561
2	- Did the Seller acknowledge how they feel about the change?	true	DE1561
1	- Did the Seller acknowledge how they feel about the change?	false	DE1654
2	- Did the Seller acknowledge how they feel about the change?	true	DE1654
1	- Did the Seller acknowledge how they feel about the change?	true	DE1679
2	- Did the Seller acknowledge how they feel about the change?	true	DE1679
1	- Did the Seller acknowledge how they feel about the change?	true	DE1781
2	- Did the Seller acknowledge how they feel about the change?	false	DE1781
1	- Did the Seller acknowledge how they feel about the change?	true	DE1833
2	- Did the Seller acknowledge how they feel about the change?	true	DE1833
1	- Did the Seller acknowledge how they feel about the change?	true	DE2013
2	- Did the Seller acknowledge how they feel about the change?	true	DE2013
1	- Did the Seller acknowledge how they feel about the change?	true	DE2734
2	- Did the Seller acknowledge how they feel about the change?	true	DE2734

I would like to present for each user and question only his last attempt,

i know i need to use aggr and max functions so how, but i wasn't able to find the solution, can someone help?

Re: Present only the max value

Thiago_Justen_ — Wed, 21 Nov 2018 13:17:30 GMT

FirstSortedValue([User Code],-Aggr([Quiz Attempt Number],[Quiz Question],User Code)) >>>>> results in User Code

Edited - there was two commas after Quiz Question:

FirstSortedValue([Quiz Question],-Aggr([Quiz Attempt Number],[Quiz Question],User Code))>>>>> results in Quiz Question

gal_polak — Wed, 21 Nov 2018 13:09:20 GMT

I tried implementing the code you wrote in the two columns,
but i get "Invalid dimension" 😞