2086102 - How to correct a null - WFA

• Creating a line chart sourced from a composite query table that contains NULL values results in gaps within the line chart.  The desired outcome is to have those gaps closed.

• 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.

• 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:

KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To