Thursday, 28 July 2016

Variable Size Bump Chart in Tableau

Using Gambling Data(Click to download)
Create Following bump chart showing each Gambling product's rank based on AVG(Daily number of bets) over time (quarter of Bet date). Size the lines by the number of distinct Gambling products in each quarter






Step1:
Drag Bet date onto the columns shelf.  Select continuous quarter.

Step2:
Drag Gambling product onto color



Step3:
Create the following calculated field 



Step4:
Drag INDEX() into Rows. 



Step5:
Right-Click on INDEX() and select Edit table calculation.

Step6:
Select "Advanced..." from compute using drop-down.



Step7:
Select Addressing  by Quarter of Bet date and Gambling product in that order.  Sort by average Daily number of bets descending.



Step:8
Select “Quarter of Bet date” from the restarting every drop down.


   Right-click on  Index axis > edit axis…


Step9:
Select “Reversed” for the scale.




Step10:
 Create the following calculated field 


Step11:
Drag  "Size" onto size


Step12:
Click the drop down on the Size,Select  Compute using > Gambling product.


Step13:
Double-click on the size legend.


Step14:
Select “By range” from the sizes vary drop down.


The desired output as below:


Thanks Guru's,
Prazval.ks






DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks