Hello,
I have created a kanban for material replenishment.
As you can see there are 2 kanban cards for each part number, one with a trigger of half total stock, and another one for if stock reaches zero.
A helpful KPI is to know the number of parts that are out of stock. However, if I set a simple analysis that works out Qty of cards where Empty=Yes and trigger =0, if the first card (trigger at half total stock) is replenished, it will be showing as Out of stock.
Any ideas for this?
I guess what I am after is a way of telling how many different parts have BOTH Kanban’s empty.
Hey Nolsie,
I think I solved this one. This explanation is a little long winded, so if you get lost at any point let me know and I will provide a little more detail. This is little bit of a tricky thing to do-
Here is my example table
Create an analytic
Create a new trigger from your desired dashboard.
Select the table tab in the top left
Select your table
Click Create analysis
Select “Single Number”
Click Change under the number section on the left.
Select “Count where True”
Click “Aggregate Functions”
Click “Count Where True”
Click on “Select a variable or function”
Seach for the “and” function, select it.
For the first filter select “Table fields”, the select “Table ID”
Click “Equals” and change it to “Contains”, Enter (2) in the string value field.
For the second filter in the and function, Click “Select a variable or function”
Select Table field
Select “Empty”
So now we are counting the records where the ID contains (2) and Where the empty field is true.
Does this make sense?
Did you get lost anywhere along the way?
Pete
