Randyb

Discussions

Employee count by month
I've been asked to build out a card that shows employee count by month, this seems easy enough until you try and factor in the termination date. What is expected is to show in each month the total active employees, so if employee A is hired on Jan 1st and terminated Feb 15th he would show as a count of 1 in January and a…
Record count for prior month or prior quarter at start of the year
I have a Beast Mode that I've been using that was working fine up until January 1st. The issue is that I have a number of Beast Modes that are calculating record counts for Prior Month, Prior Quarter and Prior 2 Quarters past. They all seem to have trouble getting past the 2018 component, which I know I've coded in the…
Single number selection from a group of numbers (Like random selection but from a controlled source)
I've got a very unusual issue. I need to select a group of workorder numbers that meet a certain selection criteria, and then from those select one. In the perfect world it would be random. I know that was a stretch so I tried put a ranking on them and thought that I could simply turn the value into Max(Value) and get my…
Setting up the Dynamics GP Connect and Company Code Issue
I am trying to set up the Dynamics GP Connector and its asking for a Company Code. I ran this through DOMO support and they couldn't tell me what or where this number would come from. I found a post about this going back to 2016 and there was no answer back then. I have reached out to our GP VAR and they have no idea what…
Using IN Beast Mode for multiple matches won't SUM
I've got a Beast Mode I built and it calculates as expected except that instead of returning the sum value of all matches it returns a row for each match. Here is the Beast Mode: SUM(Case when `title`IN ('Metal Technician','Refinish Technician','Frame Technician','Prepper','Mechanic') then (Case when…
Removing Comma's from string in Beast Mode Numeric Values
I have a Beast Mode that I'm using to trim a value from a string, the issue is that the trim contains a comma which prevents me from treating the resulting values as a number and therefore suming the totals. Here is the Beast Mode that is producing the trim value: Case When Month(`EventDateTime`)= month(CURRENT_DATE()) and…
Determine the Week of the month in Magic ETL
I'm running a sales forecast dataset and want to be able to determine what week of the month we are currently in so I can calculate the weekly sales forecast target. Such as if the month target is 100,000 and its week 1 then the weekly target should be 25,000. I can add a date calculation column that gives me the Week Year…
Exclusion Join or method to achieve the same type of result
I've got a dataset I'm working with that has a large amount of RepairOrder data, in this particular instance I'm filtering for any RepairOrders that are not closed that have costs applied to them. This is very straight forward, however I've discovered that in some cases I've got duplicates that exist, one closed and one…
Determining if a record falls on the first day of a quarter and if not collect it in the next Quarte
I have been presented with an interesting task, I have a dataset that contains all of our sales records and our company measures SSS (Same Store Sales) Year over year. I solved this fairly easily by inputting the first RO date into the dataset for each location. Now the accounting department has come back and said they…
Active Record Count as of Certain Date
I'm trying to figure out the best approach for a Beastmode or other suggestion, to count the number of Active Records in a data set for a given period of time. Each Record has a Started Date and may or may not have an Ended Date (Determines the value of Active or In Active) I would like to be able to report the Sum or…
Count the number of working days consumed or remaining month to date
I am trying to work out a Beast Mode Calculation on a dataset that I have that will tell me how many working days have elapsed since the 1st of the current month, or how many are left. I have a value in my dataset which tells me how many working days there are in the current month, I'm struggling with trying to figure out…
Sum of Value based on specific date parameters
I have a Card that is in Table view and I'm trying to populate multiple columns that are all summing a value based on specific date parameters. The issue I'm having is trying to set the parameters to autopopulate based on Current date. For example I want the sum of flagged values which match certain date parameters, at the…
Beast Mode Values are changing on Drill Down
I have a Calculation in a Beastmode that is calculating the Length of Repai Cycle. The calculation is accurate and when run on its own it produces the correct number. However if I put that Beast Mode Calculation into a Drill Down path the values displayed for that calculation are not correct. So for example I can drill…
Need some guidance to count records in a dataset and then count of a subset
I have a dataset that is made up of a number of records or sales orders, there is a completed date and this would make up the first count which is easy count of SalesOrder Completed Date. The issue is the second subset, there is also a survey date which I want to count the number of surveys taken based on the survey date.…
Sum of Nested Beast Modes not coming up with Correct Total
I've got a Beast Mode that I'm creating that is trying to come up with the average value for the sum of 5 Beast Mode Calculations. If I use the first 4 in the Beast Mode and divide by 4 I get the correct value but if I try and add the 5th Beast Mode and divide by 5 the value that is returned is not correct. The average…
Sum(Distinct Value) Trying to get the sum of?
I've got a dataset that gives me an employee count and an employee count target by location. When I view this by location it gives me the correct values with the target value coming from the following Beastmode: SUM(DISTINCT `Target`) The employee count comes from this Beastmode: COUNT(DISTINCT `WRISEmployeeID`) When I…