Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
Count(If(Num([Actual Start Date]) >= Num(Today()), ColorFlag))
Try this may be:
Count(If(Num([Actual Start Date]) >= Num(Today()), ColorFlag))
Perfect, thanks very much Sunny!