Hey, are there any plans to add `json_agg` or `obj...
# questions-and-troubleshootingd
Daniel Wiszowaty
10/23/2025, 10:26 AMHey, are there any plans to add
json_aggobject_aggDaniel Wiszowaty
10/23/2025, 10:26 AM Copy code
, json_object(
date_format(timeframe_minus_6, '%Y-%m-%d'), round(daily_gross_minus_6, 2),
date_format(timeframe_minus_5, '%Y-%m-%d'), round(daily_gross_minus_5, 2),
date_format(timeframe_minus_4, '%Y-%m-%d'), round(daily_gross_minus_4, 2),
date_format(timeframe_minus_3, '%Y-%m-%d'), round(daily_gross_minus_3, 2),
date_format(timeframe_minus_2, '%Y-%m-%d'), round(daily_gross_minus_2, 2),
date_format(timeframe_minus_1, '%Y-%m-%d'), round(daily_gross_minus_1, 2),
date_format(timeframe_minus_0, '%Y-%m-%d'), round(daily_gross_minus_0, 2)
) as sales_metrics_object