Hello,
I’m having trouble trying to view Totals in the table for Table Calculation custom columns. The totals are appearing for Custom Measures column but I need to do some calculations that is not available in measures. For all Table Calculations column, Insights is showing null in the Totals row. Any help please?
Thanks!
Hi!
Could you supply us with some screenshots?
Whats your expression in your table calculation?
Sorry for the delayed response. I’m just calculating time saved in table calculation (queue item count * manual savings). The total is getting calculated for the custom measure but not for table calculation even though both these columns show same values
Hi!
Could you show the expression for the table calculation?
Are you on-premise or on the cloud?
I’m getting the same as you, it would seem like table calculations do not support summation of totals in that way.
Insights is based on Google Looker.
I’ve found these articles:
Using table calculations | Looker | Google Cloud
Display potentially confusing table calculation totals as nulls | Looker | Google Cloud
Why don’t my totals match the values in my table? | Looker | Google Cloud
It would appear that you would have to keep your table simple in terms of columns as the total row is the basis for the table calculations total, not the actual total sum of its own column
This works:
Okay, thanks for all your inputs. I’ll try some other way to represent this data.
