pie chart in appian

Could you be more elaborate about what fields are there that are unwanted?

Just a guess for now, but I had instances in which I had to explicitly filter out empty values in the source data to prevent 'unwanted fields' to appear in a chart.

more info

We want to take only status but In status there are 6 total status out of that i want only 2 pie chart. but after selecting status it takes all 6 status. 

We want to take only status but In status there are 6 total status out of that i want only 2 pie chart. but after selecting status it takes all 6 status. 

What do you mean by "status", "selecting status", "only 2 pie chart", and "takes all 6"?

If you're trying to say you want a chart of items in the DB with a certain status, and there are some status values you don't want to be displayed in the chart at all (the only reasonable guess I can make from that info), then you'd simply update your query to manually exclude the statuses you don't want (or alternatively, manually query FOR only the statuses you DO want to show).

actually I am making invoice management system application in that status is field where status are like vendor submitted, reviwer approved ,finance proceed,finace rejected like fileds are there but we want to show only fileds vendor submitted and fianance proceed then how can we show only these two fields.

filter your query.