custom table calculation function

Hi,
We are doing a lot of calculations with Looker outputs.
Recently we're doing AB testings.
I want to create custom table calculation that get 4 values (count of a+b, conversions of a+b) and return a list of two numbers - change & significance - according to z test.

How can I create custom table calculation for that?

0 3 564
3 REPLIES 3

Is there a particular reason you need to get all of this into a single cell? The easiest approach would be to calculate each result separately. If you then need to get them all into a single cell you can concatenate the values in one final table calculation, and hide the other table calcs.

You can create a single table function to get all the values in one column like this concat( calculation1, calculation2, sum(a+B),...). 

I've seen that ab testing is easier doing outside of Looker - and because each is needed for short period of time dashboards are not needed. 

Top Labels in this Space