Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Non roll-up dataset #48

Open
3 tasks done
sachinkbansal opened this issue Jul 23, 2021 · 0 comments
Open
3 tasks done

Support Non roll-up dataset #48

sachinkbansal opened this issue Jul 23, 2021 · 0 comments
Assignees
Milestone

Comments

@sachinkbansal
Copy link
Contributor

sachinkbansal commented Jul 23, 2021

I should be able to run anomaly detection on metrics that are not additive.

Below are a few examples of aggregate functions in a dataset's SQL GROUP BY that can then be supported:
COUNT(DISTINCT)
MIN()
MAX()
AVG()
Custom Percentage calculations

Dataset SQL can have zero or 1+ dimensions. Since data cannot be rolled up, anomaly definition cannot define anomaly explosion. Instead, dataset SQL itself defines the extent of explosion.
e.g. Say a dataset has 2 dimensions and 1 metric - State, Brand, ConversionRate. This means anomaly objects must be created for each state+brand combination. We cannot have an anomaly definition for a single dimension or no dimension.

  • impacts Anomaly Definition screen and logic
  • impacts anomaly object creation process
  • RCA must be disabled for such anomaly cards
@sachinkbansal sachinkbansal added this to the v0.3 milestone Aug 4, 2021
This was referenced Aug 6, 2021
@sachinkbansal sachinkbansal removed this from the v0.3 milestone Aug 18, 2021
@sachinkbansal sachinkbansal added this to the v0.3 milestone Aug 26, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants