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

[SL-2251] [Bug] Error when trying to add a time dimension at a monthly grain as a non-additive dimension #1228

Open
2 tasks done
Jstein77 opened this issue May 22, 2024 · 0 comments
Assignees
Labels
bug Something isn't working Medium priority Created by Linear-GitHub Sync Medium Created by Linear-GitHub Sync Metricflow Created by Linear-GitHub Sync triage Tasks that need to be triaged
Milestone

Comments

@Jstein77
Copy link
Contributor

Jstein77 commented May 22, 2024

Is this a new bug in metricflow?

  • I believe this is a new bug in metricflow
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

I created a dimension called ordered_at at a monthly grain and a measure called orders with ordered_at as a non_additive_dimension. This creates an error:

  dimensions:
      - name: ordered_at
        expr: ordered_at
        type: time
        type_params:
          time_granularity: month
  measures:
     - name: order_count
        expr: 1
        agg: sum
        non_additive_dimension: 
          name: ordered_at
          window_choice: max
Encountered an error error querying against the semantic layer: Unable To Satisfy Query Error: Unable to join all items in request. Measure: order_count; Specs to join: LinkableSpecSet(dimension_specs=(), time_dimension_specs=(TimeDimensionSpec(element_name='ordered_at', entity_links=(), time_granularity=TimeGranularity.DAY, date_part=None, aggregation_state=None),), entity_specs=(), group_by_metric_specs=())

Expected Behavior

I should be able to specify ordered as non additive at a monthly grain.

Steps To Reproduce

Copy the above configs into jaffle-sl-template and try to query dbt sl query orders

Relevant log output

No response

Environment

- OS:
- Python:
- dbt:
- metricflow:

Which database are you using?

No response

Additional Context

No response

SL-2251

@Jstein77 Jstein77 added bug Something isn't working triage Tasks that need to be triaged labels May 22, 2024
@Jstein77 Jstein77 changed the title [Bug] Error when trying to add a time dimension at a monthly grain as a non-additive dimension [SL-2251] [Bug] Error when trying to add a time dimension at a monthly grain as a non-additive dimension May 22, 2024
@Jstein77 Jstein77 added Medium Created by Linear-GitHub Sync Metricflow Created by Linear-GitHub Sync Medium priority Created by Linear-GitHub Sync labels May 22, 2024
@Jstein77 Jstein77 added this to the v.34 milestone Aug 29, 2024
@Jstein77 Jstein77 reopened this Aug 29, 2024
@Jstein77 Jstein77 added Medium Created by Linear-GitHub Sync and removed Medium Created by Linear-GitHub Sync labels Aug 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Medium priority Created by Linear-GitHub Sync Medium Created by Linear-GitHub Sync Metricflow Created by Linear-GitHub Sync triage Tasks that need to be triaged
Projects
None yet
Development

No branches or pull requests

2 participants