Skip to content

Add activity graph to Product Analytics

Dmytro Zaporozhets (DZ) requested to merge dz-product-analytics-graphs-activity into master

What does this MR do?

Adds extra graph collector_tstamp to product analytics to show the number of events per day.

This MR is a small addition to !37578 (merged)

The product analytics feature is behind a feature flag and is disabled by default.

Screenshots

Screenshot_2020-09-08_at_19.12.45

Does this MR meet the acceptance criteria?

Database query

The look of the query from Rails console. (I can't use rails explain on method as it returns hash and without count its not fully accurate)

SELECT
    COUNT(*) AS count_all,
    DATE_TRUNC('day', collector_tstamp) AS date_trunc_day_collector_tstamp
FROM
    "product_analytics_events_experimental"
WHERE
    "product_analytics_events_experimental"."project_id" = $1
    AND (collector_tstamp BETWEEN '2020-09-08'
        AND '2020-09-15')
GROUP BY
    DATE_TRUNC('day', collector_tstamp)
ORDER BY
    date_trunc_day_collector_tstamp[["project_id", 21]]

Conformity

Edited by Dmytro Zaporozhets (DZ)

Merge request reports