Symptom
How to apply Time Dimension in a chart of Story Report [People Analytics]
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HXM Suite
- People Analytics
- Story Report
Resolution
Currently there are two ways to create a Time Dimension in a chart of Story Report:
1. Chart in a structure of 'Time Series'
This can be done by selecting a 'Time Series' from a 'Trend' chart structure:
2. Calculated columns
Creating a formula for time dimension will allow for more flexibility as well as use of a different chart structure.
As an example, we can have three calculated columns to show us Current Year, Last Year and Five Years Ago, that can then be applied in a Chart:
Current Year
IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE()) , 1 , 0 )
Last Year
IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE())-1 , 1 , 0 )
5 Years Ago
IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE() )-5 , 1 , 0 )
This formula can be also altered for a MONTH or a DAY.
Keywords
Time Dimension, People Analytics, Story Report, Time Series, Year, Month, Day, Date, Chart, Story Designer, Calculated Column, Annual , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To