4 Replies Latest reply on Apr 18, 2018 9:47 PM by Nitin Paighowal

# Displaying a Mean, Min and Max Line for a Time Series

I am new to Tableau and finding it a great program for working with data for my masters course.

I was looking at the Arctic Sea Ice chart that was part of Makeover Monday (Charctic Interactive Sea Ice Graph | Arctic Sea Ice News and Analysis)  and was wondering how to display an average line over a filtered date range (e.g. 2009 - 2018)?

Additionally, I would also like to plot a a shaded area between a min and max line but not sure how to do this or calculate these values over the filtered date range.

Any suggestions would be appreciated.

My current Tableau workbook is here:

• ###### 1. Re: Displaying a Mean, Min and Max Line for a Time Series

Hello,

I have attached twb file for your reference. When I opened , min,max and avg were already calculated using reference line. As far as coloring between min and max is concerned, you just need to provide the color in "Fill" when editing refrence line

• ###### 2. Re: Displaying a Mean, Min and Max Line for a Time Series

Thanks Nitin. I did manage to get the average, min and max lines, however, these are straight averages of the data. What I guess meant to say was I would like the average,min and max for each month within the filtered dataset. I assume this is how the average data has been computed on the link I provided (see below).

So instead of a 1981 - 2010 Median, I would like to compute a 2009 - 2018 arithmetic average.

The same would apply to the min and max lines.

Thanks

• ###### 3. Re: Displaying a Mean, Min and Max Line for a Time Series

Ok, I think I have managed to work out the calculations for min, max and average:

TOTAL(MIN([Extent]))

TOTAL(MAX([Extent]))

TOTAL(AVG([Extent]))

I am now having trouble getting them to display how I want them. Ideally, I would like them on the same chart as the yearly curves, but when I do that, it messes up the format.

I have, however, managed to get the data to plot on a second chart, but when Min and Max are added to the same axis, it joins the points between Min and Max.

What would be the best way to get this all onto one chart, without min and max joining and adding shading between the min and max curves?

I have attached my updated workbook.

Thanks,

Andy

• ###### 4. Re: Displaying a Mean, Min and Max Line for a Time Series

Hope this helps. I am still looking into coloring between max and min. I dont think its possible to show band of color except when you can use reference lines.