Barchart and dates

Ask a Question

Hello,

I hope some of you experts may help me 🙂

I have a barchart with dimension:

=if(month([Date of Event Reference])<month(Today()),
[Date of Event Reference Year Month],
if(week([Date of Event Reference])<week(Today()),
WeekName([Date of Event Reference]),
[Date of Event Reference]))

and it shows previous months, previous weeks of the current month and the days of the current week.

I need to color the bars like this:

if(week([Date of Event Reference]) =week(today()), green(),
if(month([Date of Event Reference]) = month(Today()) and week([Date of Event Reference]) <> week(today()), blue(),
if(num(month([Date of Event Reference])) < num(month(Today())), yellow())))

but it seems to work only the first statement:

if(week([Date of Event Reference]) =week(today()), green()

Thank you very much, any advice and suggestions will be very appreciated

0 Replies