Claire
Claire

Reputation: 23

Tableau Gantt bar coloring from specific date

Using Tableau, I would like to create a Gantt Bar where the area of each bar to the left of TODAY() has one color and the area of each bar to the right of TODAY() has another color.

Any ideas?

Upvotes: 0

Views: 191

Answers (2)

Alex Blakemore
Alex Blakemore

Reputation: 11921

FYI, You can shorten the calc to just “[DAY] >= TODAY()”. Same effect. The IF etc is redundant.

Upvotes: 0

Nicolaesse
Nicolaesse

Reputation: 2724

It depends on how your Gantt chart is made, but probably the best way to do it would be to create a Calculated Field like this

IF [Day] >= TODAY() THEN TRUE
ELSE FALSE
END

and the drag and drop on the Color square in the Marks panel.

enter image description here

Upvotes: 1

Related Questions