Skip to content

Analytics: broken chart axes, build-time frozen dates, unreferenced cubes duplicating datasets #492

Description

@yinlianghui
  • Four chart yAxis values name raw fields instead of dataset measures: case.report.ts:11 (case_number — no such measure on case_metrics), opportunity.report.ts:17,27,58 (amount — the measures are total_amount/avg_amount). The rule is documented at case.report.ts:20-23, where one chart was already corrected.
  • src/cubes/index.ts (7 cubes) and src/datasets/ (6 datasets) define overlapping metrics under different names (crm_opportunity.amount vs opportunity_metrics.total_amount, …). All dashboard/report dataset: references point to datasets; no cube is referenced anywhere, although cubes/index.ts:8 states they power the Executive dashboard.
  • cubes/index.ts:76-77 embeds raw SQL strings (is_sla_violated = true) in measure filters; :90,129 have map keys (account, campaign) that differ from their name properties (crm_account, crm_campaign); contactCube (:47-56) has empty dimensions.
  • churn.report.ts:8-12 and opportunity.report.ts:9 compute daysAgo() / CURRENT_YEAR_START at module load; in the built dist/objectstack.json these dates are frozen at build time.
  • churn.report.ts:20-21 doc block says "no activity in 60+ days" and "top revenue accounts … 90+ days"; the implementation uses 14 and 30 days and has no revenue filter.
  • sales.dashboard.ts:166 hardcodes the quota annotation at 100000; crm_forecast.quota exists per owner.
  • The pipeline_by_stage funnel widget is duplicated near-verbatim in three dashboards (crm:159, sales:130, executive:183); avg_deal_size in two (crm:99, sales:110).

Activity

  1. added
    bugSomething isn't working
    metadataDeclarative metadata — schema, security posture, UI surfaces
    on Jul 30, 2026
  2. added a commit that references this issue on Jul 30, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingmetadataDeclarative metadata — schema, security posture, UI surfaces

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions