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.
Drag Daily amount bet onto the rows shelf. Drag Gender onto the columns shelf. Drag User group onto the rows shelf and onto color.
Right-click drag Bet date onto the columns shelf. Select MONTH(Bet date).
Change the mark type to area.
Create the following calculation with name "Bump"
Replace SUM(Daily amount bet) with "Bump" Field
Click the "Bump" field drop down > compute using > Bet date.
Final Output as below: