Pie Chart with if/Count expression to show today's date

[#1]

Hi,

I have a three fields, Actual Start Date and ColorFlag, and RAG Name.

I have a Pie Chart showing the number of flags (ColorFlag) per RAG name - so the Dimension is RAG Name and Expression is:

count(ColorFlag)

I would like to only see this for today's date however, which is where Actual Start Date comes in. I've tried the following expression with no luck:

if ([Actual Start Date] >= Date(Today()), Count(ColorFlag))

This works in a Straight Table, but it does not in my Pie Chart and I have no idea why. Any help would be much appreciated.

Kind regards,

Tristan

[sunny_talwar · Accepted solution]

Try this may be:

Count(If(Num([Actual Start Date]) >= Num(Today()), ColorFlag))

[#3]

Perfect, thanks very much Sunny!