Data source loads, but can't visualize

[Simoneinthecode]

The following code ran in Looker and created a data source without issue. But when I went to create a report, no visualizations would pull up without a generic “System Error” pop up. 

SELECT
v2.id AS "Email ID",
v2.from as "From",
v2.administrative_title as "Title",
v2."subject",
DATE(v2.send_date) as "Date",
v2.total_sent as "Total Sent",
v2."open" as "Open Count",

----- all email fields

((v2."open")::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Open Rate",

v2.machine_open as "Machine Open",

((v2.machine_open)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Machine Open Rate",

v2.click as "Total Clicks",

((v2.click)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Click Rate",

v2.actions_count as "Total Actions",

((v2.actions_count)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Action Rate",

v2.donation_count as "Total Donation Count",

((v2.donation_count)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Donor Rate",

v2.total_amount_donated as "Total Donation Amount",

((v2.total_amount_donated)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Average Donation Amount",

COUNT(DISTINCT un.id) as "Unsubscribe",

((COUNT(DISTINCT un.id))::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Unsubscribe Rate",

v2.bounce as "Bounced",

((v2.bounce)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Bounce Rate",

v2.previously_bounced as "Previous Bounced",

((v2.previously_bounced)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Previously Bounced Rate",

v2.spam as "Spam Complaints",

((v2.spam)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Spam Rate",

v2.previously_spam_complainted as "Previous Spam Complaints",

((v2.previously_spam_complainted)::DECIMAL)/((v2.total_sent)::DECIMAL) AS "Previous Spam Rate",
 
 
---  demo fields - sent

count(DISTINCT CASE
WHEN m.age BETWEEN 18 and 24
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 18-24",
count(DISTINCT CASE
WHEN m.age BETWEEN 25 and 34
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 25-34",
count(DISTINCT CASE
WHEN m.age BETWEEN 35 and 44
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 35-44",
count(DISTINCT CASE
WHEN m.age BETWEEN 45 and 54
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 45-54",
count(DISTINCT CASE
WHEN m.age BETWEEN 55 and 64
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 55 to 64",
count(DISTINCT CASE
WHEN m.age > 64
AND ste.action_type='sent'
THEN reccount else null end) as "Sent 65+",
count(DISTINCT CASE
WHEN m.sex = 'MALE'
AND ste.action_type='sent'
THEN reccount else null end) as "Sent Male",
count(DISTINCT CASE
WHEN m.sex = 'FEMALE'
AND ste.action_type='sent'
THEN reccount else null end) as "Sent Female",
count(DISTINCT CASE
WHEN m.sex = 'UNKNOWN'
AND ste.action_type='sent'
THEN reccount else null end) as "Sent Unknown",

--- demo fields - open

count(DISTINCT CASE
WHEN m.age BETWEEN 18 and 24
AND ste.action_type='open'
THEN reccount else null end) as "Open 18-24",
count(DISTINCT CASE
WHEN m.age BETWEEN 25 and 34
AND ste.action_type='open'
THEN reccount else null end) as "Open 25-34",
count(DISTINCT CASE
WHEN m.age BETWEEN 35 and 44
AND ste.action_type='open'
THEN reccount else null end) as "Open 35-44",
count(DISTINCT CASE
WHEN m.age BETWEEN 45 and 54
AND ste.action_type='open'
THEN reccount else null end) as "Open 45-54",
count(DISTINCT CASE
WHEN m.age BETWEEN 55 and 64
AND ste.action_type='open'
THEN reccount else null end) as "Open 55 to 64",
count(DISTINCT CASE
WHEN m.age > 64
AND ste.action_type='open'
THEN reccount else null end) as "Open 65+",
count(DISTINCT CASE
WHEN m.sex = 'MALE'
AND ste.action_type='open'
THEN reccount else null end) as "Open Male",
count(DISTINCT CASE
WHEN m.sex = 'FEMALE'
AND ste.action_type='open'
THEN reccount else null end) as "Open Female",
count(DISTINCT CASE
WHEN m.sex = 'UNKNOWN'
AND ste.action_type='open'
THEN reccount else null end) as "Open Unknown",

--- demo fields - click

count(DISTINCT CASE
WHEN m.age BETWEEN 18 and 24
AND ste.action_type='click'
THEN reccount else null end) as "Click 18-24",
count(DISTINCT CASE
WHEN m.age BETWEEN 25 and 34
AND ste.action_type='click'
THEN reccount else null end) as "Click 25-34",
count(DISTINCT CASE
WHEN m.age BETWEEN 35 and 44
AND ste.action_type='click'
THEN reccount else null end) as "Click 35-44",
count(DISTINCT CASE
WHEN m.age BETWEEN 45 and 54
AND ste.action_type='click'
THEN reccount else null end) as "Click 45-54",
count(DISTINCT CASE
WHEN m.age BETWEEN 55 and 64
AND ste.action_type='click'
THEN reccount else null end) as "Click 55 to 64",
count(DISTINCT CASE
WHEN m.age > 64
AND ste.action_type='click'
THEN reccount else null end) as "Click 65+",
count(DISTINCT CASE
WHEN m.sex = 'MALE'
AND ste.action_type='click'
THEN reccount else null end) as "Click Male",
count(DISTINCT CASE
WHEN m.sex = 'FEMALE'
AND ste.action_type='click'
THEN reccount else null end) as "Click Female",
count(DISTINCT CASE
WHEN m.sex = 'UNKNOWN'
AND ste.action_type='click'
THEN reccount else null end) as "Click Unknown",

--- demo fields - bounce

count(DISTINCT CASE
WHEN m.age BETWEEN 18 and 24
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 18-24",
count(DISTINCT CASE
WHEN m.age BETWEEN 25 and 34
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 25-34",
count(DISTINCT CASE
WHEN m.age BETWEEN 35 and 44
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 35-44",
count(DISTINCT CASE
WHEN m.age BETWEEN 45 and 54
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 45-54",
count(DISTINCT CASE
WHEN m.age BETWEEN 55 and 64
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 55 to 64",
count(DISTINCT CASE
WHEN m.age > 64
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce 65+",
count(DISTINCT CASE
WHEN m.sex = 'MALE'
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce Male",
count(DISTINCT CASE
WHEN m.sex = 'FEMALE'
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce Female",
count(DISTINCT CASE
WHEN m.sex = 'UNKNOWN'
AND ste.action_type='bounce'
THEN reccount else null end) as "Bounce Unknown",

--- demo fields - unsubscriptions

count(DISTINCT CASE
WHEN m.age BETWEEN 18 and 24
THEN un.id else null end) as "Unsubscribe 18-24",
count(DISTINCT un.id CASE
WHEN m.age BETWEEN 25 and 34
THEN un.id else null end) as "Unsubscribe 25-34",
count(DISTINCT un.id CASE
WHEN m.age BETWEEN 35 and 44
THEN un.id else null end) as "Unsubscribe 35-44",
count(DISTINCT un.id CASE
WHEN m.age BETWEEN 45 and 54
THEN un.id else null end) as "Unsubscribe 45-54",
count(DISTINCT un.id CASE
WHEN m.age BETWEEN 55 and 64
THEN un.id else null end) as "Unsubscribe 55 to 64",
count(DISTINCT un.id CASE
WHEN m.age > 64
THEN un.id else null end) as "Unsubscribe 65+",
count(DISTINCT un.id CASE
WHEN m.sex = 'MALE'
THEN un.id else null end) as "Unsubscribe Male",
count(DISTINCT un.id CASE
WHEN m.sex = 'FEMALE'
THEN un.id else null end) as "Unsubscribe Female",
count(DISTINCT un.id CASE
WHEN m.sex = 'UNKNOWN'
THEN un.id else null end) as "Unsubscribe Unknown"

--- joins

FROM sthibodeau.full_email_an_activity as ste
    LEFT JOIN action_network.emails_ver2 as v2
        on ste.email_id=v2.id
    LEFT JOIN action_network.users as us
        on ste.recipient_id = us.id
    LEFT JOIN action_network.field_values fv
        on ste.recipient_id = fv.user_id
    LEFT JOIN action_network.field_names as fn
        on fn.id=fv.field_name_id
    LEFT JOIN ufcw_membership_final.merged_members_2023_01_jan as m
        on m.vanid = fv.value
    LEFT JOIN action_network.groups as g
        on g.id=v2.group_id
    LEFT JOIN action_network.unsubscriptions as un
        on un.email_id = v2.id
        and us.id = un.subscriber_id
    
---
WHERE fn.id in ('493986','1191125','493985','1191126')
    AND fn.owner_id in (253922, 10518)
    AND v2.total_sent>0 
    AND v2.status=5
    AND g.id IN (10518, 253922)

GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 21, 23, 25, 27
ORDER BY 1, 2, 3