Hi,
I have a graph which shows an evolution of 2 measures based on month of date. In that same visual I also want to show a reference band with a max and min value per month. The values are always the same: f.e. the first shown month is always 50, 2nd is 30,...
For those values I've worked with an index: if index=1 then 50,...
Per index I have a max and a min value, so 2 different calculations. Now I want to add those to my graph using a reference band, but Tableau is showing this as a constant and not a max or min per cell.
I believe that the problem lays with the use of the index, but I don't see any other solution.
#Tableau Cloud #Tableau Desktop & Web Authoring
I'm not sure if this is what you're looking for, but please take a look if you'd like.
Here’s a workaround idea for filling the area between the Max and Min values.
By using an area chart with some white coloring, you can achieve the effect shown in the example.
(Since transparency doesn’t work well in this case, it needs to be expressed using solid colors.)
<sample>
