Hi
I have used a caluclated Dimension in graphs. If i select particular dimension value in chart, Current selection shows all the dimensions used in calculation. For example
=
if( IsNull(CloseDate)='-1',
if(Code='amber_sla_breach' or
Code='red_sla_breach' or
Code='emergency_sla_breached' or
Code='awaiting_parts_sla_breach' or
Code='emergency_sla_breach' or
Code='onsite_red_sla_breach' or
Code='onsite_amber_sla_breach'
, BreachType
))
In Current selection box
Fields Values
BreachType SLA Breach - On Site Red
Code emergency_sla_breached, onsite_amber_sla_breach, onsite_red_sla_breach, red_sla_breach
I need to display only BreachType.
Thanks in advance.
