The date filter enables you to select null values for visualization.
The following steps use a scatter visual, which is built on the dataset Issue
Tracker
. This dataset includes issues that are created and resolved and also
issues that are created but still open. Resolved issues have a timestamp and open
issues have a null value.
By default, the visual only displays values with a timestamp. This feature enables you to configure the date filter and display null values in the visuals.
Follow these steps to create a new dashboard.
Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
created
from
Measures.resolved
from
Measures. Click the field to open the Field
Properties menu and make the following changes: if([resolved] IS NOT NULL,datediff([resolved],[created]),datediff(now(),[created]))
Click Save. assignee
from
Dimensions. Description
,
Issue Key
, Assignee
, Date Open
,
and Date Closed
.created
and
resolved
from Dimensions. created
and resolved
, in the
dashboard, with a date range from 2018-06-25 through 2018-09-12. To create
date filters in a dashboard, see Using Fixed Dates (Date Picker) Mode.The following image shows the new dashboard you created. This visual does not include the null values in the dataset. Proceed to Include Null Values in the Visual section.
Follow these steps to include null values in the visual.
Hover over the upper right corner of the resolved
filter, and click
the (gear) icon to configure the
filter.
In the Settings modal window, click the Style tab, and select the option Permit selection of NULL values.
resolved
filter, click the (calendar) icon. Notice that the Include
NULLs option appears in the dropdown menu. If the Permit
selection of Null values option is not selected in the previous step,
Include NULLs option is not visible in the dropdown.
In the following image, notice that the Current Parameters on the top right corner shows resolved.include_nulls: false, indicating that the Include NULLs option was not selected in the filter.
resolved
filter, click the (calendar) icon and now let's select the
Include NULLs option. In the following image, notice that Date Closed has a value of NULL.