Is it possible to use dynamic dates in conditional formatting?

[Mikael Helldén]

In a chart, I want to use conditional formatting to color the background if the date is before e.g. today's date. I that possible? I've tried different versions of {TODAY}, but it doesn't work.

Hard coding the date (e.g. 2024-06-15) works, but I obviously don't want to change the value every time I look at the chart.

[Shashwat Khare]

Hello @Mikael Helldén ,

This is Shashwat from Atlassian Analytics and here to help! :) 

Unfortunately, applying conditional formatting on relative date variables isn't yet supported, however, we have an existing feature request for the same as below:
https://jira.atlassian.com/browse/ANALYTICS-219

I have personally watched the FR and added you, so we help gain more traction on its implementation and also so we receive notifications on it moving forward.

I would recommend that you upvote the same so that you help add more traction to its implementation and so you receive updates in the future as well.


Best,
Shashwat

[Mikael Helldén]

Thank you for your reply, @Shashwat Khare! I've voted for the FR. :)