2 Replies Latest reply: Sep 14, 2012 11:23 AM by haagenfels RSS

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

      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.