-
Re: How to fill-down nulls from earliest instance of non-null value?
The flow consists of the following: 1. Add Formula. New column name: "Row Number", Formula: ROW_NUMBER() 2. Rank & Window. Order by "Row Number". No partition columns. New col…4 -
Re: Convert to timestamp
@vaco Timestamps and Dates columns in Magic ETL don't have a format. They will always be displayed in a way that is determined by the table or card you're looking at them in, along with your company …1 -
Re: Group By Issue
The flow looks like this: Inverse Amounts configuration: Join configuration: Restate Include / Exclude configuration:1 -
Re: Two Group By with SUM totals
You should be able to take the solution we did for Project Count with these changes: 1. Rename "ProjectId Const" tile to "Cost Const", name the constant "Planned Cost" i…1 -
Re: How to Join two Group By without matching pair column
You could add phase totals by adding another branch of the original input with its own Group By, grouping by only Phase and doing a Count Distinct on Project Id called Total Project Count, and then J…1
