One thing that I’ve noticed, and that our users also reported, is that dragging and dropping table calculation columns can cause other columns to disappear, and that table calcs can only be anchored to the right of a given pivot without causing problems. However, I couldn’t seem to find anything about this in the documentation.
Is this not how table calculations are supposed to work? If it is, is there some way to prevent users from accidentally messing up their Explores and table calculations?
Hey Rob - this is actually a known issue that engineering is working on! This is not intentional behavior, and we are working on a fix for this.
I can’t drag my Table Calculation columns to the left of my dimension columns - they’re stuck over on the right - is that part of this same issue?
Hey Dan - This is by design. Table calculations currently cannot be positioned along with dimensions or measures - they will always appear to the right of their respective group. But I’ll make sure our product team sees this.
Hi
This is indeed the case
Just wanted to note that the original issue noted in this post should have been resolved in Decembers release, 3.36.
It is still intended behavior for table calc to be to the right of dimensions if the table calc is based on a dimension, and to the right of measures if the table calc is based on a measure.
Has there been any movement on allowing calculated columns to be placed among dimensions and measures?
I just ran into this now (Looker 6.6.11) - there’s still no way to position a table calculation earlier than one of the measure’s it’s using? This does prevent some visualization options so it would be very nice to get this fixed!
+1
Yep, this is still the way table calcs work. I’m not going to move over this topic, since it has other discussion in it, but you can open a new topic in the Feature Requests category to formally request it!
Thanks - there’s an existing Feature Request that seems to be along these lines, I voted for it and added a comment - https://discourse.looker.com/t/ordering-of-table-calculations-measures-and-drill-fields/4689
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
