Compare a list of values from different records aggregated per user and time period

Hello! For one of my analysis I need to compare the task list of a single user from current week against previous week. Task list are split 1 tasks per record and they can have a variable records (can be 1 task per week per user or 100 tasks per week per user).
How can I build a calculated field that return “Yes/No” (or “1/0”) for users that have same tasks in current week and previous week?
Below a screenshot with 3 examples.
Thanks!

Hello @castalm

Will the “current week” always be the most recent week loaded into your dataset or will users be able to choose a new week and compare historical data?

Hey @castalm

Did you still need help with this question or were you able to find a solution?

Hello, Sorry for late reply!
Weeks are rolling so I need to compare always this week with t-1 week.

Solutions explored - not feasible

  1. save the tasks list in an array variable. As far as I know QS doesn’t have any array and also for-cycle to use to save the tasks.
  2. transform each tasks in a number and sum the tasks list for a week to compare with tasks list for t-1 week. Unfortunately there is not a function to transform a string in a number(I found some but are deprecated).

Any other inputs or solution will be highly appreciated! Thanks

Hello, any idea about how to address this?