Showing blanks as zero in widgets

Show Blank as Zero functionality allows you to represent Null values as zero in widgets. It is available in line chart, column chart, bar chart, stacked bar chart, stacked column chart and Combination chart.
By default, the Show Blank as Zero functionality is visible.


Aggregation Methods

For Count and Count Distinct aggregation methods, Null values are not considered. 

Consider the following example.


In the above example, we plot a line chart of Salary against Region. By default, Show Blank as zero is enabled. Since there are null values for Salary in the East Region, these null values are represented as 0.
If we turn off the show blank as zero toggle button, the chart will change to the following result.


Here, since there is no salary for the East region, nothing is plotted for the East Region.

Show Null values as blanks in Filter widget.

In Filter widget, the null values are represented by <BLANK>. if we apply filter on numerical column we will exclude nan from It and only consider given range by filter.
Date Filter with NAT Values

1. Between Option:
   1. NAT values will be visible in the result
   2. If the Min and Max values are the same, NAT values will not be visible
2. Before and After Options:
   1. NAT Values will be visible
3. In Last Option:
   1. NAT values will not be visible

Consider the following example.


You can filter the null values using filter widget. These null values are represented as <BLANK>.

In the above example we have filtered the region column with blank category.