I need to SUM more than one dimension in a looker view. How can I do that?
I need to create a measure who is the sum of these three dimensions
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
If you are putting this value on a report, adding a table calculation is possible.
Just add a table calculation under the custom fields tab when building a report.
Then insert the fields you want to sum like so.
Hope this helps!
One way to achieve a sum of dimensions is by using looker - Table calculations .
The prerequisites of the dimensions is : all dimensions that are included in the sum must contain
After saving lookML changes, you need to add the table calculation needed:
The following menu will appear, in this box the sum is created by indicating the dimensions you want to sum:
After creating the new table calculation, the output will create a green column (green color column indicates that it is a table calculation column)