Calculate Reach based on Month & Age

[garfieldm]

Hi,

I am having a hard time coming up with a set analysis for calculating reach.

I have a table like this:

Month	Age	Impressions	Reach
May-20	10	323	0.203785
May-20	20	167	0.105363
May-20	30	499	0.314826
May-20	40	360	0.227129
May-20	50	236	0.148896
Jun-20	10	370	0.395722
Jun-20	20	205	0.219251
Jun-20	30	108	0.115508
Jun-20	40	252	0.269519
Jun-20	50	228	0.24385
Jul-20	10	255	0.169887
Jul-20	20	357	0.237841
Jul-20	30	468	0.311792
Jul-20	40	208	0.138574
Jul-20	50	213	0.141905

My formula for reach is:

Reach = Impressions / SUM(Impressions) of that month.

Can you help me with a set analysis formula for Reach?

[dplr-rn]

 i understand you want denominator to be sum of impressions per month

you need to use total qualifier. try below.

essentially total qualifier you are ignoring dimension in the visualization (in below case ignoring the month)

Sum(Impressions)/Sum(total<Month> Impressions)