Render the DAP Impact users by activity panel as a table

Brandon Labuschagnerequested to merge
628026-dap-impact-users-by-activity-table into master

What does this MR do and why?

Renders the Users by activity GLQL panel as a table instead of a horizontal bar chart. The panel sits on the Adoption view of the DAP Impact dashboard.

The flowType dimension becomes an Activity column. The usersCount metric becomes a Users column. The sort flips from ascending to descending, since a bar chart puts its first row at the bottom but a table reads top down. Descending order now puts the most-used activity first.

Related to https://gitlab.com/gitlab-org/gitlab/-/work_items/628026, which asks for a Users by activity visualization on the Adoption tab. A table is one of the design options the issue offers.

The demo integration MR also enabled a trend column on this panel. That needs a GLQL feature that is still in review, so it is left for a follow-up. See References below.

References

Screenshots or screen recordings

Before After
dap_users_by_activity_before dap_users_by_activity_after

How to set up and validate locally

  1. Enable ClickHouse for analytics in your GDK.
  2. Seed AI usage data for a few projects that share one group and have members. Run this once per project: FILTER=ai_usage_stats PROJECT_ID=<id> SEED_AI_USAGE_STATS=1 bundle exec rake db:seed_fu
  3. Check out this branch and run gdk restart rails-web. The system dashboard YAML is read once per process and cached, so a restart is needed.
  4. Visit /explore/analytics_dashboards/dap_impact, choose the seeded group in the Scope picker, and open the Adoption tab.
  5. Confirm the Users by activity panel is a table with an Activity column and a Users column, sorted by users descending.

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports