3267478 - Applying Time Dimensions in Charts for Story Reports

• How to apply Time Dimension in a chart of Story Report
• Steps to create a Time Dimension in a chart are unclear.  
• Users may face challenges in applying calculated columns for time dimensions in Story Reports.  
• Difficulties in selecting 'Time Series' from 'Trend' chart structure. 

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

 There are two methods to create a Time Dimension in a chart of Story Report: 

1. Chart in a structure of 'Time Series'

Select a 'Time Series' from a 'Trend' chart structure.

2. Calculated columns 

 - Create a formula for the time dimension to allow more flexibility and use of different chart structures.  
   - Example formulas for calculated columns:  

     i. **Current Year**  
     IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE()) , 1 , 0 )  

     ii. **Last Year**  
     IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE())-1 , 1 , 0 )  

     iii. **5 Years Ago**  
     IF(YEAR([Employment#Job Information#Effective Start Date])=YEAR(CURRENTDATE() )-5 , 1 , 0 )  

These formulas can also be modified for MONTH or DAY dimensions.

Time Dimension, People Analytics, Story Report, Time Series, Year, Month, Day, Date, Chart, Story Designer, Calculated Column, Annual , KBA , ss_anonymizedkba , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To