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
- 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.
- 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?
Hello @castalm
I’m sorry about the late reply I didn’t see your response, are you still working on a solution for this?
I think the best place to solve this would be in SQL prior to ingestion. that being said, I think this older solution is probably the closest:
Thanks @duncan unfortunately due to permission I do not have access to SQL editor for this dataset. Any alternative? Thanks!