REPORTS & Creating Competition with Course Completion

Everybody loves a little competition - and if I can get leadership onboard, we might get INCENTIVES! (So, I really want this to work)

GOAL: I am looking for an exportable CSV report in "ANALYZE" that will give me a live report of each user, their course assignments (2026 or lifetime is fine, both options are preferred), a separate column for each "group", and the "Assigned, Completed, In Progress" tag/column for each course.

INTENT: To plug info into a pivot table and chart progress by department (REF: Each department has a group in my setup)

Note: (for those who want to duplicate this initiative) showcasing your findings in a vertical bar chart makes the tasks feel like a race to complete; a well-received visual for competitive teams.

CURRENT OBSTICLES:

• Pulling "Live/Current" Course Completion Status- When exporting completion/status reports, the CSV includes all attempts a user made to complete a course. Example: John Q. was assigned "Application of the Hypocritic Oath" and failed on his first two attempts but was able to "complete" it on his third try, his report would reflect three separate courses. While this still gathers the information needed, it is unsustainable when auditing 500 learners.
• Filtering CSV Reports by Group - CSV reports, when exported as "All Groups" and not by a specific one, will reflect all the user's respective groups, which is fine, except all groups are landing in one column in the same text box. While this can be manually adjusted, it is not sustainable and I am looking for a cleaner, more segregated filing system.

Our Learning & Development team is SO excited to hear everyone's thoughts/ comments/ and recommendations!