Hi,
I’ve been trying to get sum certain values for other repeated values in the table using SUM(values_to_sum) OVER(PARTITION BY values_repeating) AS total. I used the code from this post:
https://community.looker.com/blog-archives-1027/a-window-into-the-soul-of-your-data-29363However, when I create a derived table and then try to use the dimension “total” with the already created look from other views it seems that the number of “total” changes depending on what other dimensions I add in the derived table and doesn’t actually sum the values in the already created look correctly.
I’ve used table calculations to get the desired outcome, however, with the size of the table it is not very efficient so I’m trying to create dimensions/measures in LookML instead.