RETIRED: Table Calculations (3.18 Labs Feature)

(Claudia) #21

Thanks @abbywest, your answer is helping me over a year later!

1 Like

(Razwan Baber) #22

Thanks for this!

0 Likes

(Fehrmann) #23

Nice feature!

0 Likes

(Anton Beckerman) #24

Def will give it a try

0 Likes

(Ari Stern) #25

is there a way to make table calcs run faster?

0 Likes

(Paola) #26

Hey @Ari_Stern , we’re always working on making Looker faster. If you have a specific case where table calculations aren’t running as fast as you’d hope them to, feel free to send us an email at support@looker.com with your specific example so we can take a look!

0 Likes

(Nick Brown) #27

Table calculations are great. 1 thing I’d love to be able to have is some sort of totalling feature on table calculations.

0 Likes

(sam) #28

Duly noted @nick - I’ll pass your feedback along to the product team!

0 Likes

(Vishesh Dahate) #29

hello everyone ,
nice to know about this new technology,
i am a recruiter in mastech and i have an opening for a BI (Dashboard/Reporting Consultant)
Looking for a Looker expert with 0 to 1 year exp on Looker.
its a sure shot offer as the looker experts are hard to find.
please reply with your email or contact number.

regards,
vishesh

0 Likes

#30

Will we ever be able to produce table calculation if function with different type of object outcomes? For example, the outcome could be a number or a string?

0 Likes

(Zachary Michel) #31

@vishesh_dahate may I recommend your post be moved to our hiring board, https://discourse.looker.com/c/news/whos-hiring

0 Likes

(Zachary Michel) #32

@ajlooker Based on how sorting works in the application it would be difficult to return two different types of data in one column (numeric vs. alphanumeric sort). I’m curious what your problem is that is provoking the question though, as there may be some other workaround available.

0 Likes

(Anna Van Meurs) #33

Hello! I have a question - why do some of my calculations appear before my Count? I notice that these calcs end up not showing in my visualization (ie bar graph). I can’t seem to reorder the columns (of calcs).

Thanks in advance for any help!

0 Likes

(rufus) #34

@avanmeurs, If a table calculation doesn’t reference a measure, it will be treated like a dimension. By default, dimensions will always appear to the left of measures. Even if we use a table calculation to reference the dimension, i.e. ${dimension_name}, the table calc will appear to the left of measures.

The order of fields from left to right is dimensions, table calcs that reference dimensions, measures, table calcs that reference measures.

There are a couple of ways to work around this

If the dimension based table calc is a number you can do something like this to include a measure in the calc without it affecting the result:

${dimension} + ( ${measure} * 0 )

If it’s a string it’s a little trickier but something like this would do it:

if(length(${dimension_name}) + ${measure} >= 0, ${dimension_name}, ${dimension_name})

We’re using the if statement so that we can include a measure in the calculation. It doesn’t really matter if the condition in the if statement is true or false, since it will always return our string dimension.

This will force the calculations to the right of the results. Then you can click Hide from visualization on the original fields so that only the table calculations appear in the vis.

Hope that helps! If you have a particular column that is not functioning as expected, you can always shoot an email to support@looker.com and we’ll take a look.

1 Like