-
Business Days
Hello all! I noticed a post or two discussing that there was a Business Days or Workdays-type function in beta and I am wondering if there are any solutions to finding the number of business days between two dates until this solution goes live? My data is fairly straight forward; assuming two columns [Date 1] and [Date 2]…
-
Find Most Recent Date
Hey all, I am trying to find a way to locate the most recent date in a table based on rows of multiple columns. In other words, given a single case with variables X1, X2 and X3 I want the beastmode to find the latest date. So if column 1 was 1/1/2015, column 2 was 2/2/2014 and column 3 was 5/1/2016 then the calculation…
-
Timestamp Runs Recursive Dataflow Magic 2.0
Hello all! I feel like I have lost it but I am looking for a simple way to timestamp each run in a recursive dataflow. The output dataset is simply appending on top of itself with no exclusions thereby producing a new set of rows based on the latest data available in the source dataset. When I try and timestamp I am…
-
Workbench - Source File Does Not Exist
Has anyone found a solution for the "Source File Does Not Exist" error? I am using the 'Excel: On-Premise' processing method and using a network drive for storage. Even when I reconfigure and reselect the file it does not resolve and I get the above reference error. Any ideas? Thanks all!
-
Remove HTML Upon Export to Excel?
Is there any way to get the returned value of HTML code to export to Excel instead of the code string itself? For instance I have some codes that look like this: CASE WHEN IFNULL(`CX.TRACK.01`,'1/1/2099') = '1/1/2099' THEN CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px;…
-
HTML in Summary Number
Hey all! HTML is not enabled in summary numbers correct?
-
Business Days Beastmode
Has there been any progress on implementing a business days count utilizing a beastmode and or the reference of custom holiday tables? While I know this is doable using SQL, we have a lot of non-technical users that would benefit greatly from this kind of function.