6 Replies Latest reply on Mar 1, 2011 2:47 PM by Bruno Vais

# Display total average price overlapped over seller price

Hi,

I have a spreadsheet that looks like this (basically the price of 2 books solde by different sellers over 3 days)

SKU        Seller    Price    Date

Book1        A    \$10    Jan 1 2011

Book1        A    \$12    Jan 2 2011

Book1        A    \$13    Jan 3 2011

Book1        B    \$17    Jan 1 2011

Book1        B    \$12    Jan 2 2011

Book1        B    \$11    Jan 3 2011

Book2        A    \$11    Jan 1 2011

Book2        A    \$13    Jan 2 2011

Book2        A    \$15    Jan 3 2011

Book2        B    \$12    Jan 1 2011

Book2        B    \$10    Jan 2 2011

Book2        B    \$9    Jan 3 2011

I need to build a chart that displays the date as columns and the total price average line overlapping the seller averages.

I know how to display the seller averages, but how can I overlap the total average on top of this?

I attached my workbook, any help would be appreciated.

thanks

• ###### 1. Re: Display total average price overlapped over seller price

The first two options I think of are a dual axis, or a table calculation with reference line, both demonstrated in the attached.

Are either of these what you are looking for? or something else?

• ###### 2. Re: Display total average price overlapped over seller price

Hi Joe,

The first one with dual axis is the one I was looking for. It works, thanks!

One more question: is there a way to display now all the colors under the same card? Right now the sellers are on one color card and the overall average is on another. How can I combine the 2 cards so I have 3 colors on the same card?

thanks

• ###### 3. Re: Display total average price overlapped over seller price

Currently the only way I know how to do that is to pre-process or reshape your data before Tableau or use custom SQL when connecting. Is that something you would be interested in?

• ###### 4. Re: Display total average price overlapped over seller price

You mean to pre-calculate the average in a column in the table that is connected to Tableau?

• ###### 5. Re: Display total average price overlapped over seller price

Here you go, I used a UNION when connecting to the data with custom SQL, just duplicating the data. Tableau is still performing the average when you create your viz.

• ###### 6. Re: Display total average price overlapped over seller price

thanks!