You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have searched the existing issues, and I could not find an existing issue for this bug
Current Behavior
If a conversion metric specifies that either of it's input measures should join to time spine, that join never occurs.
Expected Behavior
The join to time spine should occur, ensuring that there is a row for each date in the query.
Steps To Reproduce
Add join_to_timespine: true to either measure in a conversion metric's YAML. Query the metric, and you'll see that the output SQL never joins to time spine. Example YAML:
metric:
name: visit_buy_conversion_rate_7days_fill_nulls_with_0
description: conversion rate on visits-buys on a 7 day window, filling nulls with 0 for both input measures
type: conversion
type_params:
conversion_type_params:
base_measure:
name: visits
fill_nulls_with: 0
join_to_timespine: true
conversion_measure:
name: buys
fill_nulls_with: 0
join_to_timespine: true
window: 7 days
entity: user
calculation: conversion_rate
courtneyholcomb
changed the title
[Bug] join_to_timespine not applied for conversion metrics
[SL-1802] [Bug] join_to_timespine not applied for conversion metrics
Feb 26, 2024
Is this a new bug in metricflow?
Current Behavior
If a conversion metric specifies that either of it's input measures should join to time spine, that join never occurs.
Expected Behavior
The join to time spine should occur, ensuring that there is a row for each date in the query.
Steps To Reproduce
Add
join_to_timespine: true
to either measure in a conversion metric's YAML. Query the metric, and you'll see that the output SQL never joins to time spine. Example YAML:Relevant log output
No response
Environment
Which database are you using?
No response
Additional Context
No response
SL-1802
The text was updated successfully, but these errors were encountered: