Week number and Set analysis

vchuprina — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to fix issue with missing weeks number in the chart below. The reason of problem is missing data for those weeks for Bmen account

Label use following calculations:

=$(DataMetricLabel(Sales U,0))

=$(DataMetricLabel(Sales U,1))

=$(DataMetricLabel(Sales U,2))

=$(DataMetricLabel(Sales U,3))

=$(DataMetricLabel(Sales U,4))

Variable - DataMetricLabel

'W'&only( {$<$(Dates),weekID={$(=max(weekID)-$2)}>}[Week #])&chr(10)&'$1'

Variable - Dates:

Quarter=,Year=,Month=,[Week #]=, [Week Year]=, [Week Ending Date]=

Do you have any ideas now it can be fixed?

I think I should add additional field with data for all weeks and accounts, but it not good idea)

Re: Week number and Set analysis

swuehl — Wed, 21 Sep 2016 18:17:53 GMT

What if you add Account field to be cleared in the set expression?

'W'&only( {$<$(Dates),weekID={$(=max(weekID)-$2)}, Account= >}[Week #])&chr(10)&'$1'