(Pivot table) Display correct indicator subtotals and totals

Registered by Lars Helge Øverland on 2013-06-28

Pivot table module must display the correct subtotals and totals for indicators. Currently the indicator values (often percentages) are summarized, which yields wrong results. Pivot table must summarize the indicator numerator and denominator separately and then dividing them.

The numerator, denominator and factor for each indicator value can be retrieved from the analytics API using the &includeNumDen=true parameter. The response will contain a numerator, denominator and factor column. These will be populated for indicators and data set reporting rates. For all other data types, an empty value will be included.

A general formula is defined as:

- Replace empty values as follows: For numerator, use the value. For denominator, use 0. For factor, use 1.

- Calculate: Sum the numerator values = a. Sum the denominator values = b. Find the average of the factors = c.

- If the sum of denominator values (b) = 0, then replace with 1.

- Do a * c / b to produce total value.

Blueprint information

Status:
Started
Approver:
Lars Helge Øverland
Priority:
Medium
Drafter:
Lars Helge Øverland
Direction:
Approved
Assignee:
Jan Henrik Øverland
Definition:
New
Series goal:
None
Implementation:
Started
Milestone target:
None
Started by
Jan Henrik Øverland on 2013-07-24

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.