Forum Discussion

MackenziieLane's avatar
MackenziieLane
Community Member
26 days ago
Solved

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!

accessibility
articulate 360 teams
community
other
reach 360
  • MackenziieLane's avatar
    MackenziieLane
    22 days ago

    SOLUTION: This is possible to do by curating a pivot table from the exported CSV file, but I am not seeing a solution specifically in Articulate that would eliminate a step to manually manufacture the list.

3 Replies

  • MackenziieLane's avatar
    MackenziieLane
    Community Member
    22 days ago

    SOLUTION: This is possible to do by curating a pivot table from the exported CSV file, but I am not seeing a solution specifically in Articulate that would eliminate a step to manually manufacture the list.

    • EricSantos's avatar
      EricSantos
      Staff
      21 days ago

      Hi MackenziieLane,

      Love this use case, turning progress into something competitive and visual can be really powerful.

      Based on how Reach 360 reporting works today, you’re not missing a built-in option. CSV exports include all learner attempts rather than a single current status, and when exporting across all groups, group membership is combined into one column since learners can belong to multiple groups. There isn’t currently a way to change either of those behaviors directly in Analyze.

      So your workaround is spot on, using pivot tables or other external tools is the only way right now to get a clean, department-level view at scale. That said, this is excellent feedback around reporting flexibility, and I’m happy to share this use case with the product team as they continue evolving reporting.

      Thanks for laying this out so clearly.