Analytics Pane Part 2 : Average Line

In the previous post under Analytics Pane we discussed about the constant line and its use. Today we are going to continue our discussion with the Average lines
To see how a average line work lets build a view using out Sample superstore data.
Drag region and Order Date to columns. Drag sales to rows and bring region to the colors mark. Your view will now be like this:pane 6.PNG

The above view shows the sales across four region for all the year. Lets try adding a Average line to this. When we drag the average line to the worksheet the following screen appears :
pane 7.PNG

We can see three options over here : Table , Pane and Cell. We will discuss the first two ( Table and Pane in this article and the last Cell in the next article.
Drag this average line to the worksheet and place it on ‘Table’ option. We can see that a average line comes across the sheet ( this is average value of all the bar values in the worksheet).
pane 8.PNG

Right click on the average line and we will same options ( Edit , Format and Remove as we saw in Constant line in the earlier post. Select edit and the following window will appear.
pane 9.PNG

Notice we can change the average line to be applied on Table , Pane and Cell from here as well in the Scope area.
The value of the average can be changed from the Line area. We can change the average value to total , sum , maximum , minimum etc from here.
From the formatting options we can change the format of the average line.
pane 10.PNG

Next lets try to add another average line and this time drop it to the Pane area. We will have the following view now:

Average Line.PNG
Our view has now two average one average for the entire table (Country) and  the other for each pane ( Region in our case )
I hope you guys found this article informative.

In the next article I  will discuss adding average line with a case study in or next article.

Please follow and like us: