So I was ask get the weekly data score of each team we have, but in each week only Sun - Thurs data shall be consolidated.
ex.
Week 31 = overall score from Sun - Thurs
Week 32 = overall score from Sun - Thurs
Week 33 = overall score from Sun - Thurs
and so fort…
You could achieve it in two ways:
Hi @Dawid I found an answer to it, but not sure if the best 1 out there or if I might face issues with it moving forward
I used Custom Filter
${date} = add_days(0, {week})
OR ${date} = add_days(1, {week})
OR ${date} = add_days(2, {week})
OR ${date} = add_days(3, {week})
While pivoting the “Week” it will only shows the data from Sun-Weds. it works fine at the moment, but would like to know if this workaround might cause me problem in the future.
Thank you