Conditional Formatting on Date Range

Hello! I'm trying to add conditional formatting to a weekly report to ensure comments are addressed within two weeks. I have attached a sample typical weekly report. For each unique ID, I want to calculate the difference between the last modified date for that ID and the first creation date for that ID. If it's >14 days, I'd like the cell to turn red, if not, it can stay white or turn green.

Adding a new column "Within SLA" with a "yes" (<14 days) or "no" (>14 days) would also work.

Thank you!

Tips and Tricks

Common Use Cases

Help

Accepted answers

CarlDi

Hi @Nageen,

I would worry about conditional formatting once the data has been output to excel or another consumption layer. For your alternative ask, I've attached a workflow. In summary, simply change the two fields with datetimes to a DateTime format (because it's a CSV, alteryx will read them in as strings). Then with the summarize tool, group by the ID and select "First" for the Create Time field then "Last" in the Modified Time field. Then with the formula tool, use thedatetimediff expression to bring back days as the unit. Then finish it with the conditional statement. Hope this helps!

Daterange.yxmd

All comments

Nageen

example report attached

Hi @Nageen,

Your example of date didn't contain any ID that was > 14 so I changed the month for the first ID for one of the dates so the difference would be > 14.

DateTime-Example.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703