Pie Chart reporting a subset of labels

[Jim McCaskey]

Hi there,

I need to provide a Pie Chart like this:

All labels with MYLABEL1. I want to see issues which have label of MYLABEL2 in addition and those that don’t.

Looking at it as an if statement:

If label includes MYLABEL1 then
  If label includes MYLABEL2 then
    Label = 1
  Else
    Label = 2
  End if
End if

Pie chart breakdown between Label = 1 and 2.

Any ideas?

-Jim

[tier-0 grump]

Best I can come up with is to create a calculated custom field, populate it with mylabel2 iff the labels field includes mylable2.

Then create a filter labels=MYLABEL1, use this as the filter for the pie chart and use your calculated custom field as the statistic