Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Color rows based on date

SylviaK
8 - Asteroid

Hi 

 

I have a table I would like to format such that you have alternating colors by Date, so Jan-21 is say grey then Feb-21 no color, March 21 grey again, Sept 21 no color. Can someone pls advise how that can be achieved?

 

DateIDTaskNam
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Jan-21xxxxxxxx
Feb-21xxxxxxxx
Mar-21xxxxxxxx
Mar-21xxxxxxxx
Mar-21xxxxxxxx
Mar-21xxxxxxxx
Sep-21xxxxxxxx
Sep-21xxxxxxxx

 

Many thanks, 

Sylvia

2 REPLIES 2
KarolinaRoza
11 - Bolide

Hi @SylviaK 

 

You can use Reporting tool for that, but firstly apply Multi-Row formula for rows identification.

In reporting tool there is formula if New Field = 0 or 1 then apply background color change.

 

Let me know if it helps.

Karolina

 

KarolinaRoza_0-1623056034790.png

 

 

SylviaK
8 - Asteroid

Many thanks @KarolinaRoza 

Labels