Chart Expression for Follow Up date analysis

[#1]

Hi,

I am currently building a dashboard which will include analysis to follow up opportunities.  Ideally I want to show in a chart if an opportunity is overdue, ie follow up date =today, <=today, >today (overdue).

Can anyone advise of the best expression to calculate this?

Thank you. 

[#2]

hi

try this

if(Date<=today(),oppertunity) 

[datanibbler]

Hi,

try doing it as you say it, with an IF-condition.

=> What do you want to happen if an opportunity is overdue? Only the fact? -> In that case, you don't need a real chart, a textbox that can change in colour and text would be enough for that.

HTH

Best regards,

DataNibbler

[#4]

Hi,

If u want to highlight the oppurtunities in a chart u can use if condition in dimension/Expression background like follows:

If(Date<=today(),green(), if(Date>today(),red()))

Please post sample QVW.

Hope this helps.

-Shruti