computeConstants: Select constant items

In matman: Material Management

Description

Selects items with a constant value for a specified time period.

Usage

computeConstants(
  data,
  value,
  group,
  timestamp,
  timestampFormat = c("day", "week", "month", "quater", "year"),
  currentTime,
  thresholdTime = 7,
  use_latest = FALSE
)

Arguments

data	Dataframe containing item stock data.
value	Name of the column variable containing the stock values.
group	Name(s) of the column(s) that are used to group stock data. These columns are usually the item ID or item name to group stock data by items.
timestamp	Name of the column including the timestamp. This column should be in Date, POSIX , YY-mm, YYYY-'W'ww, YYYY-mm, YYYY-'Q'q or YYYY format.
timestampFormat	Declares in which format the timestamp comes in (i.e., "day", "week", "month", "quarter", "year")
currentTime	Qualifying date for the value variable. Date must exist in data and have the same format as timestamp-variable.
thresholdTime	Time for which the value shouldn't exceed the threshold value. Number declares the time in the format of timestampFormat.
use_latest	boolean value. If TRUE data will expand and dates with noexisting values will be filled up with the latest known values.

Value

Returns a data frame listing all constant items, the date since when the stock is constant and the value of the stock since this time.

Author(s)

Leon Binder [e-mail]

Bernhard Bauer [e-mail]

Michael Scholz [e-mail]

See Also

computeUnderperformer computeOverperformer

Examples

data("Stocks")
constants = computeConstants(data=Stocks,
                             value = "stock",
                             group = "item",
                             timestamp = "date",
                             timestampFormat = "day",
                             currentTime = "2019-07-27",
                             thresholdTime = 7,
                             use_latest = FALSE)

matman documentation built on Dec. 13, 2021, 5:08 p.m.