I'm trying to create a product launch report in QV that allows me to compare how fast sales performed by month by country.
Its not a simple line chart, as a product is launched at different times (Jan for UK / Mar for Spain and maybe Apr for Italy). So want to align all the months to a single start point to see the sales velocity – see screen shot. You can see the x-axis is Month 0 / Month 1 / Month 2 etc
Not 100% sure if this works for your data, but perhaps a solution with a calulated dimension (using the valueloop function) and then an expression which caluculates the date difference between launch date and transaction date and checks that number agains the valueloop dimension.
See attatched example of this kind of solution.
If it works, I'd still recomend to try to so a solution into the script if you have lots of data, because I think using dynamic dimensions and if expressions will be slow to work with for the end user if data is huge.