Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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