3114861 - How to apply Time Dimension in a chart of Story Report [People Analytics]

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.

• SAP SuccessFactors HXM Suite
• People Analytics
• Story Report

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.

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