How to get total count of null values and field values in a pie chart?

[#1]

Hi All,

How can i get a total count of Null values, and actual values of a field and just show the totals in a pie chart?  I have a date field (CompliaceDate) that has lots of records, some with dates and some that are still blank.  I am able to create a straight table that shows the totals using 2 expressions.

1) =NullCount([Date(floor(ComplianceDate))])

2) Count([Date(floor(ComplianceDate))])

and the dimension Compliance Date.

How can i get the totals to show up in a pie chart?

Thank you in advance for your help.

[Gysbert_Wassenaar · Accepted solution]

Create the pie chart with your two expressions and no dimensions

[#3]

Hi,

Wow, that was easy.  I thought I had tried that.

Thank you,

Nicholas