I have a beast mode that calculates the number of units based off the Period (month) and how far into that month we currently are. The beast mode was working fine but once we got into Period 2 the tot…
Is it possible within an ETL to value map all the NULL values in all the columns within one function. When joining datasets and keeping all the columns there end up being NULL values all over the plac…
Not even a few weeks ago I was able to set up individual cards as scheduled reports (table format) and all the columns would show up in the emailed report. Something has changed in the last few weeks.…
I need to sum the quantity in one column based off the unique values of another column. I cannot remove the duplicates within the ETL because there are other columns with greater detail that would be …
I am trying to upload an excel spreadsheet as an Online Form so members of the team can go in and manually update sales targets,etc. I have copied and pasted the data in, named the columns, gave the d…
I am stumped on this one... I created a beast mode to calculate the number of rejections as a percentage of sales. Specific lines of data have reason codes to flag what type of transaction it is. So F…
I am looking to do case statement summing a column based off the most recent date in a date column. Below is my attempted beast mode calculation. The calculation keeps returning zero as the result. 4/…