#All0 discussing

I keep getting the following error:

Challenge Not yet complete... here's what's wrong:
Could not find 'Jane Cando' as a territory member of a service territory named 'San Francisco Area'.

However, when you look at the Territory related list you see the following:

Hi everyone,

I am very new to tableau and trying to get my heard around how to recreate what I did in excel in tableau.

As a quick bit of background info: I am a sports performance analyst and looking to create more interactive dashboards using Tableau. In particular my focus is on tennis. The dataset used will generally be pretty small (max 250 rows) and as I use Dartfish to gather the raw data the data I work with will all be string format (e.g. server name, 1st serve in, 1st serve out, serve wide, serve middle, etc. As part of a report I would like to continue to show players certain key performance indicators such as 1st serve % (i.e. how many 1st serves they hit in / total number of first serve hit.

Based on my data set, in excel this is an example of the formula used to get the answer for the above KPI:

=SUM(COUNTIFS(RawDataTable[[#All],[Server]],$C$2,RawDataTable[[#All],[Serve outcome]],"1st serve made")+COUNTIFS(RawDataTable[[#All],[Server]],$C$2,RawDataTable[[#All],[Serve outcome]],"1st serve ace"))/(COUNTIF(RawDataTable[[#All],[Server]],$C$2))

$C$2 is the name of a player where $C$3 would contain the name of the opponent. Not sure how or if it is possible to use player names as references in Tableau as would use in excel.

Any advice would be much appreciated,

Thanks,

Marc

Hello,

When filtering on a measure there is an option for picking "All values" or Specific value.

From the Super Store Example:

We create State Vs Sales.

We drag sales to the filter shelf, now it asks a question

"How do you want to filter on [Sale]"?

#ALL VALUES

⌗SUM

⌗AVG

#MEDIAN

If we select sum and say atleast 100K, it would display State Vs Sales for all the states that have sales greater than 100K.

I don't understand the option of "ALL VALUES", if we select "ALL VALUES", does it mean to say, SUM of SALES>100k and AVG of SALES>100K and MEDIAN of SALES>100K?

In what scenario do we even use an option like this?

Thanks