Content in Tableau Community Forums

display error

tableaucommunity@tableau.com — Tue, 15 Oct 2013 10:25:19 GMT

Hi!

While I use the filter, some of my views do not display properly.

Please find the screenshots below.

Thanks for your suppport, Matylda

Percent of Total based on underlying data

tableaucommunity@tableau.com — Tue, 15 Jan 2013 12:40:53 GMT

Hi!

I am trying to calculate Percent of totals. I want to compute the share of adverting (SoA) for a brand, segment or model.

SoA for a brand= sum TEURO of selected brand/sum TEURO of all brands

SoA for a segment= sum TEURO of selected segment/sum TEURO of all segments

SoA for a model= TEURO of selected model/sum TEURO of all models belonging to the “selected” segment

Please see the file attached. This is just an example for a brand with the correct numbers. The difficulty is to display the information while filtering on brand or segment or model. At the moment, as soon as I start filtering, for example Brand A, I receive 100% which of course makes sense, however this is not what I want to display. I need that the denominator calculates the total based on the underlying data and not on the selected values (shown in the table).

In my example, I want my visualization to look like this:

SoA X% (X being calculated depending on filtered data)

For example: Filter: Brand (A), Segment (All), Model (All)

SoA for Brand A: 2011= 48% and 2012= 48,48%

Filter: Brand (All), Segment (X), Model (All)

SoA for Segment X: 2011= 57,66% and 2012= 59,35%

Is there a way to solve this? Thanks in advance. Matylda

YoY difference in % for a dynamic time frame

tableaucommunity@tableau.com — Wed, 12 Dec 2012 07:50:29 GMT

Hi,

I need absolute values as well as YoY difference for sales in % for the current year and a previous year. The challenge is that I want to compare the same time frames.

In my example year 2012 includes just values for the first 3 quarters (Q1-Q3); year 2011 is so far completed (Q1-Q4), at the end, these are the numbers that I want to report:

Sales 2011 (Q1-Q3): 952.188

Sales 2012 (Q1-Q3) : 931.154

YoY difference: -2,21%

How can I achieve this?

Thanks for your support, Matylda