I have a line chart with a query similar to this:
select
case when error = 'a' then 'aaa'
when error = 'b' then 'bbb'
else 'other - '||error
end as error_group,
median(elapsed_sec) as median,
stddev(elapsed_sec) as stddev,
count(error) as error_count,
trunc(start_time,'DD') as start_time_day
from CA_VIEW
group by error, trunc(start_time, 'DD')
This displays the error_group as series with start_time_day on x-axis and errorcount as y-value.
The standard tooltip shows "Series" (error_group), "Date" (start_time_day), and "Value" (error_count).
I would like to add the values for median and stddev to show only in the tooltip.
I don't want to use a custom tooltip column (since in reality my "case" statement is more complex).
Is there any way to add an additional data value (based on median and stddev columns) into the tooltip via javascript JET formatting ?
Thanks. -alex