Hi Tableau Experts,
I am trying to create a calculation that would designate tags as below, which is the # of quarter(s) since a product's launch. Each product may have a different launch quarter and year.
Quarter(s) since launch: 0
Quarter(s) since launch: 1
Quarter(s) since launch: 2
..........
Quarter(s) since launch: 10
I've initially created a Level of Detail calculation to identify the launch quarter for a product but I can't seem to figure out the next step. The workbook is attached.
Another goal is to be able to chart out "Quarter(s) since launch" on an X-axis for all products in order to see revenue.
Hello Catarina,
From the workbook, it seems to me that you're almost very near to the goal.
Quaters since launch can be simply achieved by,
[Calc: Quarter Ranking] - [LOD: Initial Launch Quarter]
A viz sample could look like this.
The workbook is attached.
Regards
Lei
