This is a important statistic where we want to find out how much salary change is there for different Titles in the organisation across years.
UI Location | Graphic | Description |
Sidebar | Datasource & Chart Type: select [employees].[employee_norm] as the datasource and Time Series - Percentage Change as chart type
In the Time section, Select from_date as Time column , Year as Time Granularity & 100 years ago as Since column.
In the Metrics Section, select sum_salary as the Metric and title as Group By. |
|
Output | Clicking on Query, yields us the following graphic. Save this with the name Salary Change Per Role ... |