Multiple Fields count in pie chart

[#1]

Hi Team,

I have a dimension name and 4 other measures which has counts of low,medium,high risks

Can you please let me know the way to achieve this in pie chart as it doesn't allow more than 1 measure.

Thanks,

SV

[tresesco]

If you want the pie on expressions, remove the dimension. Or, you want pies on dimension values, you might opt for trellis (dimension tab).

[sasikanth]

HI,

Another way is , Create one calculated Dimension at script Level based on this Low , medium and High  if Possible

Then use this one along with your original Dimension as Drill down option

Exp is same Count()

[nagarjuna_kotha]

Hi S V ,

Pie Chart allows more thn  eone Expression but it gives only first Expression Values only.

Can u share sample files?

Regards,

Nagarjuna

[Anonymous]

Also, you can create 3 dimension fields on the base of flag at script level..

like

IF(Flag='high', Dim) as HighDim,

IF(Flag='Low', Dim) as LowDim....

Then you can create cyclic group of those dimension with the same expression