-
How do I reflect team member on Team A before date and Team B after date.
I have a team member that has moved teams on a specific date. I need this person to be still reflected in Team A prior to 8/1/23 and also on Team B on and after 8/1/23. All other team members will remain in their current team. Trying to use beast mode but getting an error. Any help would be appreciated. case when Date >=…
-
ETL join is matching multiple values - not exact matches
I am joining two datasets and the result is matching multiple values from the second data set to a single value in the first data set. Is it possible to have the join only match exact values? Example: Data Set 1 Data Set 2 Join result Join = Left Outer Left Table = Data Set 1 Right Table = Data Set 2 Matching Column = ID…
-
Converting Week Numbers to Dates for custom week date range (Monday - Sunday)
Currently, I am using the DOMO out of the box solution for converting week numbers to dates. This works great for a Sunday to Saturday week; however, a request is being made to view our week as Monday - Sunday. I have attempted DATE_ADD and WEEK variations but have been unsuccessful. Here is my current Beast Mode:…