pie chart

[#1]

Hi,

Pie chart normally show the relation between a single dimension and a single expression.Is it possible if I want to show only required data in that dimension?I mean,if in one column there are Inprogress,Pending,Closed and I want to show only pending and progress.Is it possible?If so,how?

[Anonymous]

You can use calculated dimension, like this:

aggr(if(match(FieldName('Pending','Inproggress'),FieldName)),FieldName)

And, you have to suppress wen value is null

Or, just select the values you want...

[terezagr]

Hi,

see attached example

[#4]

Hi,

Yes it is possible

1. You can use filter in set analysis expression

Ex: =Count({<Column={'Pending','In progress'}>}Column)    // It will return the Pending and In progress counts

Where column will be your actual column which holds In progress,Pending,Closed.

2. You can use a calculated dimension as well

Hope it helps you..

Regards,

Ravikumar

[arulsettu]

HI

Try like this

if(match(field,'Pending','Inproggress'),field)

in calculated dimensions

[kiranmanoharrode]

Hi Ramya,

Mention your required dimension values in set analysis.

for ex.

=Sum({<Stock_Status={"Pending","Inprogress"}>} Stock)

Regards,
Kiran

[agomes1971]

Hi,

like this?