Symptom
Environment
- Workforce Planning and Analytics
Cause
- The gaps are caused due to the differences between a '0' value and a NULL value. Having a NULL value (data does not exist in the database) in the query will yield gaps in the chart because there is no data returned.
Resolution
- In the Composite Query, add 0.000000001 at the end of the Expression so that when calculated, it will have a miniscule value of '0' instead of NULL and will reflect that in the line chart and table as seen below:
Keywords
KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To
Product
SAP SuccessFactors HCM Core all versions