Reputation: 23
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
Reputation: 11921
FYI, You can shorten the calc to just “[DAY] >= TODAY()”. Same effect. The IF etc is redundant.
Upvotes: 0
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.
Upvotes: 1