# Holistics AMQL/AQL Resources

## Knowledge

- [AQLearn: Learn Holistics AQL](https://play.amql.org/learn/welcome)
  Interactive Holistics AQL course with 32 lessons, exercises, and runnable demo data. Use as the primary practice sequence for this workspace.
- [Holistics: What AQL is for](https://docs.holistics.io/as-code/aql/learn/what-aql-is-for)
  Core mental model: define metrics once, query them anywhere. Use for explaining why AQL exists.
- [Holistics: Defining a Metric](https://docs.holistics.io/as-code/aql/learn/defining-a-metric)
  Metric definitions, metric composition, and AQL-defined dimensions. Use for writing reusable business logic.
- [Holistics: Filtering](https://docs.holistics.io/as-code/aql/learn/filtering)
  Difference between `where()` and `filter()`. Use when debugging wrong counts or misplaced filters.
- [Holistics: Grouping and Aggregation](https://docs.holistics.io/as-code/aql/learn/grouping)
  `group()` and `select()` table-expression pattern. Use for query-shape practice.
- [Holistics: Cross-Model Queries](https://docs.holistics.io/as-code/aql/learn/cross-model)
  Relationship-driven querying without explicit SQL joins. Use for dataset modeling and customer explanations.
- [Holistics: Metric Context](https://docs.holistics.io/as-code/aql/learn/metric-context)
  How dimensions, filters, relationships, level of detail, and windows shape metric results. Use for advanced debugging.
- [Holistics: Level of Detail](https://docs.holistics.io/as-code/aql/learn/level-of-detail)
  `of_all()`, `exclude()`, and fixed-grain thinking. Use for percent-of-total and context override patterns.
- [Holistics: Nested Aggregation](https://docs.holistics.io/as-code/aql/learn/nested-aggregation)
  Aggregating an already-aggregated result. Use for “average monthly”, “max per customer”, and similar questions.
- [Holistics: Time Comparisons](https://docs.holistics.io/as-code/aql/learn/time-comparisons)
  Period comparison functions such as `relative_period()`. Use for YoY, QoQ, trailing, and running-total metrics.
- [Holistics: Explore Expressions Reference](https://docs.holistics.io/reference/aql/explore-expression)
  Explore block syntax for dimensions, measures, filters, relationships. Use for report-level AQL.
- [Holistics: Table Expressions Reference](https://docs.holistics.io/reference/aql/table-expression)
  Table pipeline syntax. Use for row-level and grouped table query practice.
- [Holistics: Metric Expressions Reference](https://docs.holistics.io/reference/aql/metric-expression)
  Metric expression structure and examples. Use as syntax authority.
- [Holistics: Metrics by Example](https://docs.holistics.io/as-code/amql/metrics-by-example)
  Question-to-pattern map and snippet gallery. Use when choosing which AQL feature fits a business question.

## Wisdom (Communities)

- Holistics internal/team review channels
  Use for metric-definition critique, dataset relationship questions, customer-facing explanation checks, and real-world edge cases.
- Customer/presales calls and follow-up threads
  Use for testing whether explanations land with non-data-engineering audiences.

## Gaps

- Need workspace-specific examples from real customer/presales cases once available.
- Need curated “common debugging failures” from existing AMQL projects.