Do you feel that you are Tableau Expert? Then try this challenge 23

Hello All…

I am back with new challenge. This is very common scenario. Example finding customers who purchased in 2017 and purchased in other year. Similarly, customers who purchased milk also purchased bread like that.

If you have this kind of challenges or looking for tableau expert help in your work reach me on Suresh.n2008@gmail.com

Note: Please download the Data from below link to solve this challenge. If you use this data, results should match with images posted.

Click Here to download Data

Below you can see number of customers over the years trend.

There are 637 customers who purchased in 2013.

Now I would like to know how many of these 637 customers purchased in other years. See below image. Out of these 637 customers, 484 customers purchased in 2011. Similarly, 451 and 557 customers in 2012 and 2017 respectively.

More examples for year parameter and Region filter changes.

For more challenges: Click Here

Experiment… Observe… Learn…

Scenario 17: Color and Arrow KPI Implementation in a report

Look at this below report. Are you getting useful information or insights quickly? How much time it will take to identify negative profit sub-categories.

Let change above report into visual KPI (Key performance Indicator) representation. Don’t you like it? :)

Let see how to build this report.

Step 1: Build sheet like below

Step 2: we missed to show header for 3^rd column in report. Now drag Measure names into filter shelf, then select profit only. All remaining should be unselected. Then drag measure name into column shelf. Drag measure values into “Text” shelf. Remove sum(profit) from Marks shelf.

Step 3: Now we will write calculation for KPI indicators.

KPI Indicator:

If sum([Profit]) >= 0 then '▲' else '▼' END

Now you might get doubt how I used up and down arrow symbols here. I copied Unicode characters from google. Search for Unicode characters in google and then copy symbol into calculation.

Step 4:

Place KPI Indicator on color and text shelf.

Step 5: Re-arrange labels in text shelf.

Final report looks like this

Scenario 16: Invidual color legend for each measure in the view

Hello All,

After long time, I learned handy tip for coloring individual measures in single sheet. This feature is released in 10.2 version. It works 10.2 version onwards.

See it is to build view like below.

But I want to represent each measure with different color gradient. How it is possible?

In 10.2 tableau released feature for this. If you right click on measure values which is there on color shelf you will find option “Use separate Legends”. See below

Now view looks like below

If you format different color schemes for different measures view looks like below

Do you feel that you are Tableau Expert? Then try this challenge 22

Hello All…

Here I am coming with new challenge.

For this challenge data looks like below. Only one column which shows dates. You can prepare data by yourselves and try this challenge.

I have data like this, Date starting from Oct 1^st, 2017 to Sep 30^th, 2018.

Here the challenge showing week of the month. My week starts from 1^st Sunday of month. See below image.

If you see above image, I am showing week of the month column in this report.

As I told earlier, week of the month will start from 1^st Sunday of month. For example, in 2017 Oct 1^st starting from Sunday so Oct 1^st to Oct 7^th is week 1 and so on. Coming to November first Sunday starting from 5^th so week 1 from 5^th Nov to 11^th Nov. Dates before 5^th Nov will be week 5 of previous month.

So, try to write logic to display week of the month.

For more challenges: Click Here

 Experiment… Observe… Learn…

Do you feel that you are Tableau Expert? Then try this challenge 21

Hello All…

Here I am coming with new challenge. Most of challenges which I have been posting here are not what I faced. Different people colleagues, friends or blog followers sends these challenges. I solved for them. This challenge I solved for my blog follower.

Note: Please download the Data from below link to solve this challenge. If you use this data, results should match with images posted.

Click Here to download Data

Build chart looks like below:

 In above line chart, we are showing two lines for same metric. Metric selected in View by parameter. Here Metric1 is selected in parameter. Now We are calculating Average and Latest date values for that Metric 1.

This report shows Metric1 values by Hours.

Average line is average of Metric1 values during that date range selected in filter.

Latest Date line is sum of Metric1 values for Latest date in this data set.

In this data set Oct 31 is latest date. So Blue line indicates Metric1 values for Oct 31 data.

Whereas orange line indicates Avg. of Metic1 values during Oct 27^th to Oct 28.

Once you downloaded data and start developing this chart you will understand this challenge better.

Similarly, you can select Metric 2 from view by parameter. It looks like below.

For more challenges: Click Here

Experiment… Observe… Learn…

Sets in Tableau

As per my view I can say 3 types of sets.

•         Constant Set
•         Computed Set
•         Combined Set

Constant Set:

Create set by selecting values of dimension. These values won’t change dynamically. Values which you selected will be IN Set, other values will be in OUT set.

Computed Set:

This set we will create based on logic. For example, we will create Top 10 Customer by Sum(sales) or Customers whose sales more than 1 Million.

Combined Set:

This is nothing but combining two sets. To create combined set, both sets should be created on same dimension.

For Example, I want to see how many customers are there in Both Top 10 by Sum(sales) and Top 10 by sum(profit).

Step 1:

Create Top 10 Customers by Sum(sales) set. Right Click on Customer Name and create set.

Step 2:

Create Top 10 Customers by Sum(profit) set. Right Click on Customer Name and create set.

Step 3:

Right Click on “Top 10 Customer by Sum(sales)” set and select create combined set.

You can select how you want to show members from both sets. In this example, I would like to show Customers who are all there in both sets.

Do you feel that you are Tableau Expert? Then try this challenge 20

Hello All…

Here I am coming with new challenge. Most of challenges which I have been posting here are not what I faced. Different people colleagues, friends or blog followers sends these challenges. I solved for them. This challenge I solved for my friend. Let me see how you will think about it. It might look simple. Once you start solving then you will understand complexity in it.

Note: Please download the Data from below link to solve this challenge. If you use this data, results should match with images posted.

Click Here to download Data

I just want to show “Average of Top 10 orders by sum(sales)” for each quarter. See below image.

So, each quarter you should find top 10 orders by sum(sales). Then you should calculate average of those top orders.

Please look at below images for more result examples:

Example 1:

Example 2:

Example 3:

 For more challenges: Click Here

Experiment… Observe… Learn…

Do you feel that you are Tableau Expert? Then try this challenge 19

Hello All…

Here I am coming with new challenge. Most of challenges which I have been posting here are not what I faced. Different people colleagues, friends or blog followers sends these challenges. I solved for them. This challenge sent by my previous company colleague. It’s very quick thought process for me. Let me see how you will think. I did not used any functions to solve this.

Click Here to download Data . Use this dataset to solve this challenge.

See below image.

Simple line chart: order date by sum(sales). Show 4 reference lines based on dates shown in red color.

Now the challenge if I change Order date range filter then reference lines which are in between date range should show other reference lines should not visible. See below

In above image, I filtered data before 11/16/2012. So only 2 reference lines which will fall under 11/16/2012 to 12/31/2014 date range.

Similarly, you can see more examples below

Example 1:

Example 2:

Example 3:

 For more challenges: Click Here

Experiment… Observe… Learn…

Tableau Expert Info Blog Feedback