Full Accumulation with Dimension

[#1]

Does anyone know how to fix below?

I am using a simple sum function to calculate the expression. I have chosen to use full accumulation to see this information over time and have added a dimension.

However, when I add a dimension, it looks like it doesn't calculate back if the dimension didn't exist.... Please see images below.

Does anyone know how to fix this? The chart with the dimensions should have the same overall values as the chart below (without dimensions).

[MK_QSL]

Please provide some sample data....

[#3]

Hi,

Very sorry for my late response.

I think the values are Null... or the data stops coming in for the specific field... I have included 3 charts.

The bar chart without the dimension is how it should look. Do I need to make changes in the script (replacing Null values with numerical value 0) or is this something I can do on the front end UI?