I'm getting infinity i statics component

💬 Queries and Resources
, ,
1

Screenshot 2024-03-21 at 11.53.34 AM
Screenshot 2024-03-21 at 11.53.34 AM1370×1112 125 KB

  • Goal:

  • Steps: This is the query

with
cte as (
select
date,
agency,
brand,
brand_enable,
ad_account_id,
ai_group,
ai_group_status,
ai_group_type,
platform,
sub_platform,
campaign_id,
story_enabled,
cast(total_spends_usd as decimal) as total_spends_usd
from
retool.spends
where
ai_group_id = 'Null'
)
select
round(SUM(total_spends_usd), 2) as total_spends
from
cte