Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
Load
Store,
if(Product like '','Empty','Value')) as [Product Value]
from...
Bar Chart:
Dimension: [Product Value]
Measure: Count(Stores)
regards,
sam