Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have this formula for a Bar chart:
Count({<[AAA]={'Oui'},[BBBB]={'FR'}>} [XXX])
I would like to integrate this formula into the conditions:
weekname (DateA) = weekname (DateB)
like this :
Count({<[AAA]={'Oui'},[BBBB]={'FR'},weekname (DateA) = weekname (DateB)>} [XXX])
but it does not work
Try like this?
Count({<[AAA]={'Oui'},[BBBB]={'FR'}>} If(weekname (DateA) = weekname (DateB), [XXX]))
may be like this
create field for week
weekname (DateA) as WeekA
weekname (DateB) as WeekB
Count({<[AAA]={'Oui'},[BBBB]={'FR'},WeekA = {"=WeekA =WeekB")}>} [XXX])
or
create a flag
if(WeekA =WeekB,1,0) as Flag
Count({<[AAA]={'Oui'},[BBBB]={'FR'},Flag = {1}>} [XXX])
Thanks,
Priyanka
I think I misspoke
il would like the final results
Do a left join
Table1:
Load week,
NB2
Source tb1
Left join(Table1)
Table2:
Load Week,
NB
Source tb2
Thanks,
Priyanka