GrantSmith Coach 
-
Re: Find Employees Manager Manager
You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.1 -
Re: where to find the append/replace feature for a google sheet in DOMO dataset?
It's not supported with that connector. If you need to append data you can feed it into a Magic ETL dataflow and then set the output tile to Append. You can have it trigger on the initial Google shee…1 -
Re: Average Nested Bar
Nested bar charts only support showing the overall total. I'd recommend utilizing a Symbol + group bar or a Line + group bar chart and have the average be the symbol or line1 -
Re: Modify formula
MIN(MIN(CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END)) OVER (PARTITION BY `PlantID`,`Date`) You can use a window function to return the minimum…1 -
Re: Can I see the basic dataset length between different steps of an etl flow?
Currently this isn't an option directly within Magic ETL but would be a much welcomed addition. I'd recommend adding an idea to the Idea Exchange for this. You could output your dataset before and af…2
