ratio_decomp: Decomsition of hierarchical data indicators

Description Usage Details Examples

Description

Convert data.table with numerator and denominator values to data.tree.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
dt2tree_ratio(data, tree_name, numerator_name, denomiator_name, dim_names,
  mode = c("diff", "lag"), diff_postfix = "_diff",
  lag_postfix = "_lag", na.rm = TRUE)

agg_tree_ratios(node)

decomp_ratios_parent(n, multipl = 100)

decomp_ratios_parent_full(n, multipl = 100)

decomp_ratios_root(n, root_denominator_curr, root_denominator_lag,
  multipl = 100)

decomp_ratios_root_full(n, root_denominator_curr, root_denominator_lag,
  multipl = 100)

Details

dt_to_tree_ratio() converts relational data into data.tree suitable for drilldown of ratio values.

decomp_ratios_parent and decomp_ratios_parent_full relats nodes' data relative to immediate parent node

decomp_ratios_root and decomp_ratios_root_full relats nodes' data relative to root of the tree

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
tree <- dt2tree_ratio(DT,
                      tree_name       = "Total",
                      numerator_name  = "cost",
                      denomiator_name = "income",
                      dim_names       = c("region", "name"))

tree$Do(decomp_ratios_root_full,
        root_denominator_curr = tree$denominator_curr,
        root_denominator_lag  = tree$denominator_lag,
        multipl = 1)

vh-d/hierarchical documentation built on July 5, 2019, 12:23 p.m.