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.
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).