I have a dataset which is updated once a month. The graph shown is meant to have the most recent month (here October) in a highlight colour, as well as the latest two Octobers for reference.
Currently, I'm updating the colour manually. Is it possible to have this happen automatically?
twbx attached
@Lise Kok Petersen
Hi, you may use something like:
IF DATEPART('month',[date_start (Union)]) =DATEPART('month',{MAX([date_start (Union)])})
THEN "Highlight"
END
Optionally, you may right click on the pill in the filter shelf and select add to context (That way the fixed calc {MAX([date_start (Union)])} would be calculated after evaluating the filter.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
