Effective remunaration (career path category) - distribution of staff by remuneration and age

[superette]

ref #5

[superette]

Some proposition to formalize indicator for developpment :

proposition 1

• slice 20-30 ; 30-40
• sum(female), sum(male) where is in slice
• for all genders, for all slices

proposition 2

• Type = Tier : range
• Interval = 10 or 5 years
• Type mesure = count

• Group by = gender

  dimension: employee_age_tier { type: tier style: integer tiers: [10,20,30,40,50,60,70,80] var: ${employee_age}; } dimension: employee_annual_remuneration_tier { type: tier style: integer tiers: [20,30,40,50] var: ${employee_remuneration};; }

  dimension: employee_gender { type: string var: ${employee_gender};; }

  measure: Effective_remuneration1 { label: "age_rem_gender" type: count var: ${employee_age}; ${employee_remuneration}; ${employee_gender} }

in dashboard, call the 2 dimensions of the key (age) to use by filter (gender, remuneration).

[superette]

• Ratio : percentage
• Distribution : count
• Bucket : slice

First level of bucket on remuneration Second level of bucket on age.

Distribution

• Define bucket : remuneration

• Code :

  gender, count(people) from people 
  group by gender 
  CASE remuneration in (0>=25) ; (25>=35) ; ...

• Define bucket : age

• Code :

  gender, count(people) from people 
  group by age 
  CASE age in (18>=25) ; (25>=35) ; ...

Percentage

• Define bucket : remuneration

Code :

with subselect as (count(*) population from people)
gender, count(people) / subselect.population from people 
group by gender 
CASE remuneration in (0>=25) ; (25>=35) ; ...

• Define bucket : age

Code :

with subselect as (count(*) population from people)
gender, count(people) from people  / subselect.population from people 
group by age 
CASE age in (18>=25) ; (25>=35) ; ...