set anlysis - only include 2016 data

[#1]

Hi, guys.

I'm struggling with an Expression. I want the Expression below to only include Pledge donors recruited in 2016.

I want to calculate the share that has InnbetalingsStatus='Har innbetalt' in 2016 amongst all Pledge donors recruited in 2016 - FadderskapOpprettetÅr=2016.

Can you please help me out here?

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},2016={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) /Count(DISTINCT {<2016={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)

Best regards

Christian

[sunny_talwar · Accepted solution]

May be this:

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}, FadderskapOpprettetÅr = {2016}>}AKTORID_FS_LOPENR)/Count(DISTINCT {<FadderskapOpprettetÅr = {2016}>} AKTORID_FS_LOPENR)

[Anonymous]

Hello Christian,

are you sure that your Year Field ist 2016? 2016 should be in [] Brackets ([2016])

Maybe select 2016 over your Year Listbox so then your Expression should look like this:

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR)

/Count(DISTINCT AKTORID_FS_LOPENR)

If you want to make the Expression over the Variable, then it looks like:

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},2016={$(FadderskapOpprettetÅr )}>}AKTORID_FS_LOPENR)

/Count(DISTINCT {<2016={$(FadderskapOpprettetÅr )}>}AKTORID_FS_LOPENR)