for an example i use a table like this:
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?
Would Munich and Berlin be included in both with and without value in product?
Yes,count each store and show the number of stores with value in product and number of stores with no value in product.
I did it by script:
if(Product like '','Empty','Value')) as [Product Value]
Dimension: [Product Value]
Retrieving data ...