#WorkoutWednesday0 diskutieren mit

@Hemang Dave

Hi, you can take a look of:

https://www.tableau.com/learn/certification

And there is a special training for Data Analyst:

https://www.tableau.com/learn/training/data-analyst-certification-prep

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

Hi Pawan,

One option would be to use blending to join the two data sets. Have you come across blending before? It's a bit like a left outer join (in join terms). Data from the secondary data source is aggregated which imposes some limitations, but it can also be handy. I've attached / described an example which may be similar to yours below, and included a link to the data blending info. Take a look and post back if it helps or not. If you including a sample workbook people will be able to get their teeth into any specific problems you're hitting with your data.

Data blending: Blend Your Data - Tableau

Example:

I used category instead of country but have a similar look up of % to your screenshot.

I added this spreadsheet as an extra data source as well as using sample superstore. I also pivoted the data above so that I have a row per day of month and category. That way I can define a relationship between the two data sources as follows:

Then I can build the view out as follows:

With a [Factored Sales] calc of: SUM([Sales]) * MIN([Sheet1 (day-product-perc-lookup)].[Perc])

Meaning that we see the sales factored by the relevant percentage in our look up sheet as illustrated for Furniture on 3/01/2018; 10% of sales of $1,593 is $159.

NB: The use of MIN when pulling in the percentage is just because we have to use an aggregation; the data is setup so that there should only be one record matching at any time anyway so the aggregation you pick is irrelevant.

I've attached the workbook I used in case it helps. Let us know!

Hi there,

this was an exercise for ⌗WorkoutWednesday​ Week 39 last year.

Here is VizartPandey website instructions.

Here is the official website and instructions.

thanks,

Adrian

I don't believe the annotation can be truly dynamic in the way that you are hoping. You can, however, use a label on the text mark that will be dynamic and will only label the selected mark (open circle). I mocked up the following. If you think this will work, then please read on.

Create three different calcs, each of them ensuring that the fruit in the viz matches the fruit in the parameter. If it does, then show the label and if it does not, then yield a null:

@Label Selected Fruit 

IF [Fruit] = [Select fruit] THEN [Fruit]

ELSE NULL

END

@Label SomeXValue

IF [Fruit] = [Select fruit] THEN 'someXvalue: ' + STR(INT([someXvalue]))

ELSE NULL

END

@Label SomeYValue

IF [Fruit] = [Select fruit] THEN 'someYvalue: ' + STR(INT([someYvalue]))

ELSE NULL

END

Add those to the marks card on the shape axis. I knocked down the opacity on the color a bit as well. Now, that label will only appear on the mark in the parameter.

Attached is a workbook. Let me know if this helps 😄 .

Thanks,

Kevin Flerlage

Josh,

You can replace your label calculation with

STR( IIF(MAX([Current Month Temp]) = WINDOW_MAX(MAX([Current Month Temp])),MAX([Current Month Temp]),NULL) ) + '°'

ALT-248  to get the degree symbol

Hi Alex,

Try below things on regular basis to become more comfortable with Tableau.

2) Tableau Expert Info: Real Time Scenarios

3) Makeover Monday | A weekly social data project

Hi Meenu,

To display labels correctly, your formula should be