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?
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.