Case statement with two conditions

Hey!

I have a case statement below for inventory to create a pie graph.

Case
WHEN `AVAILABLE_COUNT` <= 20 THEN 'Out of Stock'
WHEN `AVAILABLE_COUNT` >= 40 THEN 'Sufficient Stock'
Else 'Low levels'
End

The only problem is that I have 2 warehouses I included as filters. However, when the data populates it separates the two locations as different entity and counts it separately.

If warehouse A has inventory, but warehouse B has no inventory, then it counts for two status.

Even if both warehouses have inventory, it still counts as two status because of location.

I want to have the total inventory counted as one status in both warehouses.

Sorry, if this is confusing. Let me know if you need any clarifications.

What should include in this beast mode calcuation?

Thanks!

Find more posts tagged with

Comments

Godzilla

Can you show a sample of your data/scenario?

data.PNG

Pie Graph.PNG

user03543

The Total should only be 149, but since there are two warehouses it counts as 298.

data.PNG

data.PNG

Anyone?

data.PNG

Pie Graph.PNG

rado98

A way to go around the issue, but nto solve it as such, would be to combine the two warehouses using ETL then either create a separate DataSet or append it to the original and calling it Warehouse A+B in the Warehosue column.