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 1st, 2017 to Sep 30th, 2018.

Here the challenge showing week of the month. My week starts from 1st 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 1st Sunday of month. For example, in 2017 Oct 1st starting from Sunday so Oct 1st to Oct 7th is week 1 and so on. Coming to November first Sunday starting from 5th so week 1 from 5th Nov to 11th Nov. Dates before 5th 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.



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 27th 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.


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…

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

Hello All…

Here I am coming with very complex challenge. Let me see how you will solve this challenge. 

Don’t forget to share your solution with me. Please send your solutions to suresh.n2008@gmail.com

Look at the dataset below
Category
Date
Time available
Allocation Code
Category 1
1/1/2017
24
Calendar Time
Category 1
1/1/2017
22.46564641
Planned delay
Category 1
1/1/2017
21.65061065
Unplanned delay
Category 1
1/1/2017
16.62751987
Break
Category 1
1/1/2017
16.25161727
Unknown
Category 2
1/2/2017
24
Calendar Time
Category 2
1/2/2017
22.46564641
Planned delay
Category 2
1/2/2017
21.65061065
Unplanned delay
Category 2
1/2/2017
16.62751987
Break
Category 2
1/2/2017
16.25161727
Unknown
Category 3
1/3/2017
24
Calendar Time
Category 3
1/3/2017
22.46564641
Planned delay
Category 3
1/3/2017
21.65061065
Unplanned delay
Category 3
1/3/2017
16.62751987
Break
Category 3
1/3/2017
16.25161727
Unknown

Note: Data might be same for Category 1, Category 2, and Category 3. Filter for Category 1 and build below chart.

DO NOT modify above dataset to solve this challenge. Use same and try to solve



By seeing this chart, itself you can understand what we are showing. If not please follow below explanation.
  • Total Calendar Time is 24 hours. That is first bar in above chart.
  • 1.53 hours is difference between calendar Time and Planned delay. If you see that bar is starting from 24 hours (top to bottom) and ending at 22.45 hours. The height of the bar is 1.53 hours.
  •  0.82 hours is difference between Planned delay and Unplanned delay. But it will start from end of Planned delay bar.
  • Similarly, for Break and Unknown bars. Difference from previous value.
  •  Now whatever remaining is there, should display as Remaining bar.

Go through chart clearly, you will understand the challenge.

 For more challenges: Click Here
Experiment… Observe… Learn…