Window Calculations (Partition by) gives different results depending on what (unrelated) fields are in the table

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-29363

However, 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.

0 0 264
0 REPLIES 0
Top Labels in this Space
Top Solution Authors