Hi,
We have a requirement to have standard colors for the open/closed risk items. The green/red color combination gets applied to Bar charts just fine.
When the same thing is applied to pie charts and the value for appearance is set to &COLOR. the charts change color to black. Any guidance regarding this will be much appreciated.
The sql we use is below -
select label,cnt,metric_def,case label
when 'Open' then 'Tomato'
when 'Completed' then 'LimeGreen'
end as Color
from (
select 'Completed' label,
sum(actual_nbr) cnt,
mi.metric_def
from ( select sm_subtype_lov,
sum(actual_nbr) actual_nbr
from metrics
where metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERTS')
and metric_date = ( select max(metric_date) from metrics
where metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERTS')
and metric_subtype_lov = cert_pkg.get_metric(1)
)
-- VFK539/04-30-2019 -- commented out line 18,35 and replaced with 19,36 because the mover pie chart was changing values when the cert cycle values were being changed
-- and metric_subtype_lov = cert_pkg.get_metric(nvl(:p2100_cert,cert_pkg.get_cert_id()))
and metric_subtype_lov = cert_pkg.get_metric(1)
group by sm_subtype_lov
) a,
metric_infos mi
where mi.metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERT SUMMARY')
group by mi.metric_def
union
select 'Open',
sum(missing_nbr) cnt,
mi.metric_def
from ( select sm_subtype_lov,
sum(missing_nbr) missing_nbr
from metrics
where metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERTS')
and metric_date = ( select max(metric_date) from metrics
where metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERTS')
-- and metric_subtype_lov = cert_pkg.get_metric(nvl(:p2100_cert,cert_pkg.get_cert_id()))
and metric_subtype_lov = cert_pkg.get_metric(1)
)
and metric_subtype_lov = cert_pkg.get_metric(1)
group by sm_subtype_lov
) a,
metric_infos mi
where mi.metric_type_lov = lov_pkg.gk('METRIC_TYPE','CERT SUMMARY')
group by mi.metric_def
)