User Profile
filipeanalytics
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Re: Merge reference or duplicate query into source query
Thanks a lot for the fast reply lbendlin! I'm trying to join my main query to a summarized version of it, so I don't think I can do that by merging the query to itself. Is there a way to do the equivalent of a sql SUM window function? SUM(salary) OVER(PARTITION BY dept_id) AS dept_total_salary Because in the end what I'm trying to do is to create a new column using SUM partitioned by two other columns. Below is the image of the summarized table, which is a reference to the main query. And my goal is to merge this to the main query (which has the granular data) by year and category. The referenced query becomes unavailable for merging when I try to do a merge from the main query:
