FE - Ai User Metrics Sorting

Overview

BE - Add sorting support to aiUserMetrics Graph... (#581293) introduces a sort parameter for the AiUserMetrics graphql query, we should update the frontend tables to utilize this

TODO

  • Refactor DataTable to use GlTable when we require sorting (GlTableLite does not support sorting) - !214721 (merged)
  • Implement sorting for as many fields as we can

Fields

Code suggestions usage by user

Required sortable fields:

  • User last duo activity
  • Code suggestions shown (codeSuggestions.codeSuggestionShownInIdeEventCount)
  • Code suggestions accepted (codeSuggestions.codeSuggestionAcceptedInIdeEventCount)

Unsure:

  • Code suggestions acceptance rate % - we might not be able to sort by this fields since we calculate this on the frontend

Code review usage by user

Required sortable fields:

  • User last duo activity
  • Reviews requested (codeReview.requestReviewDuoCodeReviewOnMrByAuthorEventCount)

Unsure:

  • Reactions to review comments - this is a sum of reactThumbsDownOnDuoCodeReviewCommentEventCount and reactThumbsUpOnDuoCodeReviewCommentEventCount which we currently calculate on the frontend

RCA usage rate

Required sortable fields

  • Usage (troubleshootJob.troubleshootJobEventCount)

Questions

  • How should we handle the fields that are calculated on the frontend ? (We likely need to skip them for now)
  • Should we be able to sort by User last activity?
Edited by Ezekiel Kigbo