Wondering if someone can help. I have a data source which contains information on routes that are operated by seasons. A route can appear in more than one season.
In Tableau I am wanting a list of these routes which can be filtered by Season. The data source also contains information on if the route was a new route for that season
Route AA is operated in both S1 & S2. Route AA was new in S1.
However the data is duplicating when I bring in the New Route as a color. I want AA to only show once and be highlighted as New for S1 but when you filter on both S1 & S2 seasons it duplicates the AA value.