Bar chart example needed

[#1]

Hi All,

I have a table which list me the list of person and thier company they work for can some one help me to design a chart which will tell me how many people is working for which company?

[Anonymous · Accepted solution]

Add a dimension, Company, then create an expression, Count(Person).

Modify the field names above to fit your data and you should be set.

[#3]

Hi,

Your example helped me now I get the count of people working for each company. But now I have one more problem it looks like the table will have same person with different company names and also a date field called joining date. So now I want to represent in a BAR Chart saying how many people have changed from say a company A to Company B. is that really possible in chart?