ThirdEye computed metrics

[Ivan Korhner]

Hi,

I am testing ThirdEye for anomaly detection of analytics user data. I am not sure how to do the following:

We want to detect drop in retention which is calculated from the following table:

User (id of user)

Registration Date (date user registered)

Last Login Date (date user last logged in)

Example of day 1 retention formula:

Retention % = Count of all users who have last login date = today / Count of all users  who have registration date = yesterday

We cant combine it into a single metric as it is a percentile metric and it is not additive (you can't break it down by dimensions and sum it).

I tried using AutoOnboardPinotMetadataSource to ingest metrics from pinot, is it possible to manually specifiy how metrics are imported and import it as a "complex" metric that has to be recalculated from multiple metrics?

[iv...@nordeus.com]

Solved, derived metrics can be added via /thirdeye-admin page