-
Beast Mode Appears to only be Calculating First Part
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 total is only calculating the total for the first period. Something is causing it to stop and I cannot pinpoint what the cause…
-
Value Map all columns at once
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 place. This has been notorious for making Beast Modes fail. My fix for this is to add a bunch of value map functions at the end…
-
Emailed Scheduled Reports Format Changed
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. Only the first two columns now show up in the scheduled report in the email. Anyone know what is happeneing? Everyone on my…
-
Sum Column Based on Distinct values in another column
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 lost if done. So i need a beast mode that would give me a result of 50 for the sample data below. Any help is appreciated.
-
DOMO Online Form - Unable to Save
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 dataset a name, filled in all the null values but the save button grays out. Hovering over it will pop up a box saying "Your…
-
Beast Mode not calculating for Current Year to Date
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, H, etc are specific type of rejection lines. The "0" is a normal sales transaction. The beast mode below calculates…
-
Case statement using date field
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/20/19 is the most recent date in my date column so anytime it finds that date I want it to sum the value in the 'Greater…
