topic Formula in count Condition in App Development

Formula in count Condition

pittouti — Fri, 15 Jan 2021 10:13:35 GMT

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

Anil_Babu_Samineni — Fri, 15 Jan 2021 10:21:17 GMT

Try like this?

Count({<[AAA]={'Oui'},[BBBB]={'FR'}>} If(weekname (DateA) = weekname (DateB), [XXX]))

PriyankaShivhare — Fri, 15 Jan 2021 10:23:41 GMT

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])

create a flag

if(WeekA =WeekB,1,0) as Flag

Count({<[AAA]={'Oui'},[BBBB]={'FR'},Flag = {1}>} [XXX])

Thanks,

Priyanka

pittouti — Fri, 15 Jan 2021 14:00:00 GMT

I think I misspoke

il would like the final results

PriyankaShivhare — Sat, 16 Jan 2021 03:20:21 GMT

Do a left join

Table1:

Load week,

NB2

Source tb1

Left join(Table1)

Table2:

Load Week,

Source tb2

Thanks,

Priyanka