I have a request in to somehow analyze and perhaps visualize how many inventories were/are available per day. This might be more simple than I am envisioning, so I hope that’s true.
Our inventories have a bit of complexity to them as well. For instance, we only consider the inventory to be “available” between a range of dates that are associated with the particular unit.
Consider the following table of information. This shows 2 distinct parts (ABC and DEF) each with 2 lots, for a total of 4 distinct records. Each record has a date range associated with their availability.
If I extend this table to show by day with a “1” indicating that the unique record is available that day, the first ten days of the month would look like this:
|Total of Part ABC||2||2||2||2||2||1||1||0||0||0|
|Total of Part DEF||0||0||0||0||1||2||2||2||1||1|
From the table, I now know the total number of unique items that were available per day as well as by part which items were available by day.
This is what I am looking to do with some SQL or BAQ code.
I am not really sure where to start, so any guidance is much appreciated!