Hi,
I have two tables, and want to get some aggregated values from Table 2 to Table 1. I do NOT want to blend or join Table 1 and Table 2. I do not even know if it is possible to get the aggregated values to Table 1, without joining or blending the tables. But, let me explain further.
Say this is Table 1
(This is actually a very simplified version of Table 1)
DateTimeNameCompanyCalculated Field 111-10-2019 11:35JohnMango= select sum (Table2.Website Sessions) where (Table2.DateTime=DateTime+600 AND Table2.Name=Name)12-10-2019 14:19JohnNotion Press= select sum (Table2.Website Sessions) where (Table2.DateTime=DateTime+600 AND Table2.Name=Name)12-10-2019 12:28ChrisNavnon= select sum (Table2.Website Sessions) where (Table2.DateTime=DateTime+600 AND Table2.Name=Name)20-10-2019 18:30AnaStark Corp= select sum (Table2.Website Sessions) where (Table2.DateTime=DateTime+600 AND Table2.Name=Name)
Say this is Table 2
(This is actually a very simplified version of Table 2)
DateTimeNameWebsite Sessions11-10-2019 12:20John311-10-2019 12:21John111-10-2019 12:23John320-10-2019 18:00John512-10-2019 16:30John112-10-2019 16:45John4
In "Calculated Field 1", I want to query Table 2 for some records, and get the aggregated value. See the formula I want to use in Table 1 above, but without the right syntax. My question then becomes - what is the right way and syntax to do this?
1 answer
