How can I increase/decrease the count in the charts based on a condition?

Hi There Can you please give some more details what you are trying to achieve. You can use iif(condition,true,flase) but until I fully understand what is your requirement I would not be able to give you right direction. Manu thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

I have a field called Counrty which is a varchar(1000). The values in that columns are sometime single value and sometimes mutilple values with comma(,). Single value - USA Multiple values - USA, China, India When I am desiging a chart for count(projects) countrywise, I want to add a count to USA, if the field contains USA. How do I do this and where do I do this? Any help would be greatly appreciated.

Hi There is this country is a field in your dataset or a parameter inside your Report Please Update many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi There Please try this expression =count(iif(INSTR(Fields!Country.Value,"USA") >0,1,nothing)) Im putting some screenshot for your help. If you have any questions please ask. Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Syed, Thanks for the reply. How can I write a single expression to get the count of all the countries.. and make the graph to display only the one country name on the x-axis.

Hi There ca Can you please elaborate further what you are trying to achieve. The expression which I have given you above will count the country USA in the dataset how many time it appears as you can see from the screenshot, now what is your next question Are you trying to count all countries in that string? Whether you would like to have distinct count like if a country appears three times in the dataset you would like to count once Please give me some more details Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

I appreriate your help. Can you please picture a bar chart which has count in the y axis and country in the x-axis and let me know how do I display that chart. The chart now has x-axis like USA (1) USA, China (1) USA,INDIA(1). I want to show the chart like this USA(3) Chian(1) INDIA(1) Again, Country - x axis Count - Y - axis

Hi There I would suggest you please do it inside your SQL query or Stored procedure. It will be far easier to do inside your Stored procedure Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Actually, the datasource is Sharepoint! :)