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.
Step7:
Select Addressing by Quarter of Bet date and Gambling product in that order. Sort by average Daily number of bets descending.
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.
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