Friday, 29 July 2016

Conditional Bump Chart in Tableau

On Bettings data(Click to Download):-
Create below bump chart of SUM(Daily amount bet) over continuous month of Bet date segmented by User group and Gender that meets the following conditions:
·         If the current month is greater than the same month of the previous year, add 1.
·         If the current month is greater than the previous month, add 2.
·         If the current month is less than the same month of the previous year, subtract 1.
·         If the current month is less than the previous month, subtract 2.



Step1: 
Drag Daily amount bet onto the rows shelf.  Drag Gender onto the columns shelf.  Drag User group onto the rows shelf and onto color.



Step2:
Right-click drag Bet date onto the columns shelf.  Select MONTH(Bet date).


Step3:
Change the mark type to area.


Step4:
Create the following calculation with name "Bump"


Step5:
Replace SUM(Daily amount bet) with "Bump" Field


Step6:
Click the  "Bump" field drop down > compute using > Bet date.


Final Output as below:



Thanks Guru's,
Prazval.ks




Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)? Step 1: Create  3  calculated fields  “Cust Name Wi...