Replace null values in joint Dataset

MALPI

Hi all,

i got a problem in creating a Bar-chart.

For this chart, i've made a joint dataset which contains the following headers:

provider_thisMonth, flights_thisMonth, provider_lastMonths, flights_lastMonths.

This Month and Last Months are two different Datasets. When i join them it might be that a provider that exists in last Months does not exist in this month. So the value of the row will be set null.

My chart should be the following. On x-Axis I got all providers, on y-Axis i first got the sum of all flights in the passed months stacked on it is the sum of all flights in this Month.

If there are null values i get an exception. If I Filter the null rows, the data is ignored. So is there any option to replace the null values in dataset?

Cheers,

MALPI

mwilliams

You can create a computed column for each column that has null values caused by the join and check for null values and replace those with whatever value you'd like.

Hope this helps.