Row context to calculate WoW, YoY, PoP

Question & Answer
5

Hi @seichyi, thanks for this.

This is what I’m trying to do, but

  1. I don’t want to use static parameters like your ${yearselection1} (I want the value in this parameter automatically recognized)
  2. I cannot use now() function, instead I would like to use the max(string) function that seems not exists (here the issue Max of String (sorted in alphabetical order) in a calculated field - #4 by robdhondt)
  3. I would like to use your logic, but with a dimension that is filtering the dates (ex 2021-40 is filtering the year to 2021), and use the year field dynamically so getting, for eg., {year}-1 ignoring the “indirect” filter on the year. (indirect because I used year_week in the visual).

Thanks,