How to get only 2 values in a bar chart from a lot of values?

[Anonymous]

Hi,

for an example i use a table like this:

Store	Product
Munich	Handy
Cologne	TV
Berlin	PC
Munich
Munich
Munich	XBOX
Berlin

Now i want to create a bar chart wich shows the number of Stores wich have a value in product and not.

Can i do this by a chart expression or only by (load) script?

regards,

sam

[sunny_talwar]

Would Munich and Berlin be included in both with and without value in product?

[Anonymous]

Yes,count each store and show the number of stores with value in product and number of stores with no value in product.

[Anonymous · Accepted solution]

I did it by script:

Load
Store,
if(Product like '','Empty','Value')) as [Product Value]
from...

Bar Chart:

Dimension: [Product Value]

Measure: Count(Stores)

regards,

sam