Counting date and empty cells to create pie or bar chart

[#1]

Please help,

I will like to create a bar  chart or pie chart that will count cells with "date" values, cells with "NA" values and "empty" cells.

Please refer to the image to help out here.

Thanks

[rwunderlich · Accepted solution]

You could use a Calculated Dimension like:

=if(trim(DateCompleted)='', 'Empty'

,if(DateCompleted='NA', 'NA'

,'Date'

))

and an Expression

=sum(1)

-Rob

http://masterssummit.com

http://robwunderlich.com

[#3]

Thanks Rob! You saved the day!

Works perfectly!

• Not Closed is my 'Empty'
• NA is 'NA'
• Closed is 'Date'

And I changed the 'Background Color' in the 'Expression' tab.