UI: Admin Configure Average Consumption

Description

This is the UI ticket for https://openlmis.atlassian.net/browse/OLMIS-924#icft=OLMIS-924

As an implementer, I want the option to include the "Average Consumption" (P) attribute on the requisition forms so that the user (storeroom and program manger) can see and understand what the typical or average consumption for that commodity is while he/she is making a request for more products.

Note: if the periods within a schedule are monthly, this calculation will serve as Average Monthly Consumption (AMC)

New Feature: implement the option for an implementer user to define the number of periods to average. This is a new option and part of the P attribute.

Acceptance Criteria
Verify that:

  • an implementer (who is an authorized UI user) can configure this field to appear in the Requisition template for their program

  • an implementer (who is an authorized UI user) can configure it with a field label string

  • P is available to be associated with a requisition template by program

  • can be assigned a display order in the requisition form

  • average consumption is based on a period moving-average window of adjusted consumption (N) from most recent period(s)

    • (N t0 + N t-1 + N t-2 + N t-n) / (n -1)

  • Calculated in the browser

  • user defines "n" (to indicate how many periods will be averaged)

  • "n" cannot be 1 or 0, must be greater than or equal to 2

  • "n" must have a value if (P) is selected to be displayed/included in the template

  • n = number of periods

  • t = indicates relative period (t0 = current reporting period)

  • if not enough periods exist, compute based on the number available

  • if no previous periods, use N

  • if one previous period, average the periods that exist

Variable

Indicator

Associated Table

Remarks

Adjusted consumption for a reporting period

N

RequisitionLineItems table

saved for prior periods in the RequisitionLineItems table—t subscript indicates relative period

QAlity Plus - Test Management

Checklists

Activity

Mary Jo KochendorferJanuary 4, 2017 at 5:47 PM
Edited

I'm moving to dead as the above is covered in the sub-task of OLMIS-924.

Nick ReidDecember 22, 2016 at 8:36 PM

https://openlmis.atlassian.net/browse/OLMIS-1544#icft=OLMIS-1544 is the product grid implementation of this column

Mary Jo KochendorferDecember 22, 2016 at 7:31 PM

shall I split this ticket into two, one for the admin UI and one for the product grid? let me know what the pattern is.

Won't Fix
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Priority

Time Assistant

Created December 22, 2016 at 7:25 PM
Updated February 8, 2023 at 1:29 PM
Resolved January 4, 2017 at 5:46 PM

Flag notifications