Exec Dashboards: New page backend POC with "Metrics comparative table "

Manage:Optimize

Overview

This issue is for the backend work in the Exec Dashboards new page POC.

Splitting from Exec Dashboards POC with the "Product Analytics... (#372502 - closed) and from the full Exec Dashboards spec.

Problem to solve

GitLab Analytics provide high value to executives. However, these reports are spread across multiple pages in GitLab and may require specific filters to be applied to be relevant. Executives' time is very valuable, and we want it to be intuitive for them to use GitLab to get insights that are relevant to their business.

Screen_Shot_2022-09-15_at_2.51.09_PM

Proposed solution

Build proof of concept of on a new page with "Metrics comparative table ".

  1. Create a new group-level page /analytics/exec_dashboards.
  2. The new page will contain custom table view with multiple gitlab metrics.
  3. The API queries will be against gitlab-org production database.
  4. Each tile should have a drill-down link into other GL analytics reports.
  5. The new page will be behind a feature flag.
  6. Page name "Exec Dashboards POC".
  7. View "Edit" mode don't need a detailed UI, it can can be customized via yaml or json.
  8. Metrics filter options - per project and / or sub-groups.
  9. For this POC the measurements dimensions will be time period.
  10. Columns headers - Name | Period 1 | Period 2 | Change % | Description
  11. Timespan for the POC - 90 days
  12. Name - Metric name
  13. Period 1 - period 1 value. For the POC = Last full calendar month.
  14. Period 2 - period 2 value. For the POC = Previous full calendar month (-2).
  15. Change % - % = (Current period Value – Previous period value) / Previous period value
  16. Description - Open text
  17. Each value need to be displayed with value_unit - (e.g. deployment frequency with "/day", Lead Time for Changes "days", Change Failure Rate "%")

This specific issue requirements

  • Create a new group-level page /analytics/exec_dashboards.
  • Add a feature flag for the new page.

Acceptance criteria

Compare DORA Deployment Frequency value and change rate % across 4 different projects.

Out of scope:

  1. Table sorting
  2. Change badge with colors (Red/Green
  3. Sparklines to show data trends.
  4. Sub-views
  5. Add Target / Goal value (configure manually by the user).
  6. Specific date range

Validation

Edited by Sarah Waldner