3114861 - How to apply Time Dimension in a chart of Story Report

How to apply Time Dimension in a chart of Story Report 

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 HCM Suite
  • Analytics & Reporting
    • 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, 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

SAP SuccessFactors HCM Suite 2511 ; SAP SuccessFactors Platform 2511