Hello @jcrodriguez , welcome to the Quicksight community!
Do you want to be able to do this all within the same table? If so you may be able to achieve this with filter if all of the data in DATALIQPH is formatted the same way. i.e “2022-abr”
What you could try if the other solutions don’t work is create a the following parameters with controls set up for specific values that you designate:
Period = Month, Quarter, and Year
Month = List Months
Offset Slide = However many years increments you want to go back
I suggest following the steps explained here:
For you months parameter, you will need to create a new calculated field that says something like this:
ifelse(
${Months} = "January" AND contains({DATALIQPH}, "jan"), {DATALIQPH},
${Months} = "February" AND contains({DATALIQPH}, "feb"), {DATALIQPH},
etc....,
NULL)
Let me know if this helps!