最後に新しくレポートを作成します。このレポートでSQLを、
SELECT
distinct t.id as ticket,
summary 'ストーリー',
p.value '可能性' ,
i.value '影響',
((CASE p.value WHEN 'high' THEN 3 WHEN 'middle' THEN 2 WHEN 'low' THEN 1 ELSE 0 END) + (CASE i.value WHEN 'high' THEN 3 WHEN 'middle' THEN 2 WHEN 'low' THEN 1 ELSE 0 END)) as risk
FROM
ticket t
LEFT OUTER JOIN ticket_custom p ON (t.id = p.ticket AND p.name = 'influence')
LEFT OUTER JOIN ticket_custom i ON (t.id = i.ticket AND i.name = 'possibility')