DR KPI Framework (for non AR reports)

From UG

(Difference between revisions)
Jump to: navigation, search
(Improve Design)
(Solution version 1)
Line 28: Line 28:
==== Level 1 ====
==== Level 1 ====
-
DR KPI on Level 1 is a table of KPI(one or more) per sepecified time frame
+
DR KPI on Level 1 is a table of KPI(one or more) per sepecified time frame.
-
* [[TBD]]
+
==== Level 2 ====
==== Level 2 ====
Line 39: Line 38:
  * add "Download to Excel" button
  * add "Download to Excel" button
-
DR KPI on Level 2 is a chart of one KPI (on Axis Y) that reflects averaged value of KPI's amount
+
DR KPI on Level 2 is a chart of one KPI (on Axis Y) that reflects averaged value of KPI's amount per sepecified time frame and grouped by certain parameter (on Axis X).
-
per sepecified time frame grouped by certain parameter (on Axis X).
+
==== Level 3 ====
==== Level 3 ====
* breakdown on '''Group By''' parameter
* breakdown on '''Group By''' parameter
* add new KPIs and update list of Output Fields
* add new KPIs and update list of Output Fields
-
* KPI overlapping - several KPI's in adjacent columns
+
* KPI overlapping - display several KPIs in adjacent columns
==== KPI settings ====
==== KPI settings ====

Revision as of 14:34, 6 January 2012


Contents

Info

  • 0003034 (* DR/KPI) ....... <proj>

Core Need

To produce common approach (if possible) to multiple DRs/KPIs in the system

Requirements

See these wikis:

Solution version 1

Preliminary works

  • need to fix known bugs to make proper calculations on Level 1
    • including error message for "previous year" period

Improve Design

Level 1

DR KPI on Level 1 is a table of KPI(one or more) per sepecified time frame.

Level 2

* Change list of indicators showed on Axis X - Time, Carriers, Consignees, Shippers
* Change "time period" dropdown - remove "Days" / Group By instead Axis X
* Show "Time Period" controls (now radio buttons) only for Time indicator
* Linear chart for Time, bar chart - for others
* Carrier and Truckers should be the same (now aren't)
* add "Download to Excel" button

DR KPI on Level 2 is a chart of one KPI (on Axis Y) that reflects averaged value of KPI's amount per sepecified time frame and grouped by certain parameter (on Axis X).

Level 3

  • breakdown on Group By parameter
  • add new KPIs and update list of Output Fields
  • KPI overlapping - display several KPIs in adjacent columns

KPI settings

  • default Time Frame
  • default Group By
  • TBD

History

0003131: [DR/KPI] DR KPI Framework (for non AR reports)

Personal tools