-
What is a Beast Mode to calculate days and months between dates?
I am trying to calculate days between dates; Current Date and Start Date. I need the length of assignment in days, and then eventually months. I am using the below Beast Mode, but my Length of Assignment in Days is off. The current date is 4/8/2025 for all, but I cannot figure out what the problem is. Any ideas?
-
How do you add lines to a pivot table?
I am sure this is easy, but how do I get lines in my pivot table? I believe it has to do with duplicate fields, such as the dates. But is there a way?
-
Why would a dataset that comes in daily sometimes change the date format?
I have had this data set come in daily now for 6 months or more, and now for the second time in 1 month the data is wrong, and it seems to be an issue with the date format. Any reason why the date format would change? The correct format is 2025-03-24, but yesterday some of the dates formatted to 3/25/2025, therefore…
-
How can I add a Week Ending Date to my current Data?
I have a dataset that comes in daily through an email connecter from my ATS. The report is replaced each day with new data. I want to see starts per day, which I can get. I also want to see total starts per week in trends; such as a 13 week trend etc. But my data does not have a week ending date on it. What is the best way…
-
How do I change a grand total from Sum to Average?
I have the below pivot table. I want the grand total to be an average, not a total. When I changed the aggregation to average, the grand total line disappeared; see second screenshot. The column Sales Difference is a formula calculated in ETL, so I am not sure if that is the problem.
-
Why is my grand total a negative?
I am trying to find out why the total is -$379,041. If you add up Week Ending Dates for the Test 1 Forecast, it should equal $710,766. What am I missing?
-
Can I subtract two fields if the first field has a beast mode calculation?
I want to subtract Amount from Test1 by using a beast mode. For example; week ending date 1/5/2025 I want to have a column for the difference of $514,953 - $154,400. In my test1 column I am using the SUM(Distinct) best mode. Will this cause me not to be able to subtract? I am not able to get a column that shows a…
-
Can I use a Beast Mode for Null/Blank Values?
I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay? Second issue is the 27,504.75 minus…
-
Is everyone experiencing latency with Domo?
The status site says everything is running, but I can't get into any datasets. I just get spinning. Wondering if this is a systemwide issue or just my instance.
-
Is there an ETL tile to change a row into a column header?
I am not sure of the best way, but is there a way for me to take the raw data below and make a table and/or chart?
-
Can I use a ETL or Beast mode to calculate starts and ends and show in a chart?
I have data showing the start and end date, such as the below. I want to use a chart to show starts & ends side by side by week. Is this doable with a ETL or beast mode? CandidateName CompanyName StartDate ActualEndDate Name1 Company1 12/23/2024 Name2 Company2 12/23/2024 Name3 Company3 12/23/2024 Name4 Company4 12/23/2024…
-
How do I exclude data with a future date?
I am trying to pull data on a daily basis of headcount, but I have data that has future start dates that I want to exclude. Is there a beast mode I could do so? For example, today, I want to exclude any date after 12/19/2024. I would need to have a beast mode filter out daily any future date data. Is this doable? StartDate…
-
Error when converting a String Column to Floating Decimal
I am trying to convert a string column to floating decimal, but I get the below error. How can I fix?
-
What is the best why to change the format of data in a cell?
I have a data set that brings in names under the column BDM Name with FY 2024 at the end of the name, see below screenshot. What is the best way to remove the "FY2024?" I have about 8 BDM names I need to change. Should I use a replace text tile in ETL?
-
Does a PDP on a data flow work on drill downs?
I have a PDP added to a data flow based on a department. This is working great on my card/dashboard, but when I drill down, it is showing all departments. Shouldn't the PDP also work on a drill down?
-
Does the PDP automation use credits?
I am new to PDP, and I wonder if it is worth using the PDP automation in the toolkit, or is it better to set up the PDP right on the data flow. And do you get charged credits with both options?
-
How do I fix a string error with a date?
I am getting the below error and now sure how to fix. I run this data weekly, so I am assuming I have bad data somewhere.
-
How can I remove duplicates with a beast mode?
I want to remove duplicates from 1 or 2 columns, whichever is the easiest. I prefer the match ID column, or it also could be the Candidate column. I want to count each match ID once per the PPED (period end date.) I want to get a active count of matches on billing each week. If i can't do with a beast mode, I can also try…
-
How do I correct a data flow that has a "String" error?
I am getting the below error on a data flow that has been working well for months. How can I fix this?
-
Can I move a variable to one column from another?
I want my Credit Type 1 to have just Position Owner or none, and Credit Type 2 to have Candidate Owner or none. Can this be done? I was trying the below SQL statement, but it is not working. SET Credit Type 2 = Credit Type 1WHERE Credit Type 1= 'Candidate Owner' AND Credit Type 2='none" I am just learning SQL, so still not…
-
How can I change a cell that has not data to say "none?"
Hello, I have data set that I used the split column in magic ETL. If the column has a blank cell, I want it to say none. Is this possible in ETL or a beast mode? Below is the example, where there is yellow (credit type 2), I want it to say none.
-
How do I add a total to a column when I added a Beast Mode?
I added a Beast Mode so I would only get the Fee to list once since the Position ID is listed multiple times. I need to see each line so I can have a count on how many candidates per position. have I used - SUM(DISTINCT Fee). It works great, but how do I now get a total for the column? Raw Data This is the pivot.…
-
Can I introduce a new column on an existing data set? If so how?
I have an existing data set that I bring in weekly and I use the Append tile in ETL. I started about 3 months ago. 2 weeks ago I added a new column on the data set, but it is not an option when I am creating new card on my dashboard. How can I get this new column to show up?
-
How can I get the company names on a pivot table to show up on one line? One company is not.
I am using a pivot table to collect daily data on a sales funnel. I want to see what is in a particular stage of the funnel on a daily basis. I have one company that is showing up on two different lines, but the rest of the companies are on one line. The name is spelled correctly, so I don't understand the issue. Any ideas?
-
If there a way to identify what companies are falling out of a sales funnel stage, such as Best Few?
Below is an example of a pivot. I want to show only the companies that are in blue with a zero for week ending 9/22/2024. They were in the funnel stage of Best Few for the week ending 9/15/2024, but now they are no longer at this stage. I want to see weekly which companies are no longer in the Best Few Stage.
-
When listing the top 20 companies for hours, how can I remove a company that has no hours?
I have listed the top 20 companies (I have hidden the names) but I am getting a company name on top that has no hours, but I can't seem to filter it out. Any ideas i can filter out automatically? I don't want to have to filter each time this card is updated.
-
Can you use SQL or Magic ETL to change the color of cells based on decreasing values?
Hello, I have a sales pivot table that I want to highlight when sales are decreasing. Is there a way to highlight a cell if it is less than the previous cell (basically if cells are decreasing month to month?)
-
I have a column that is called Bill Amount. Why would some cells be blank?
I have tried changing to a floating decimal and integer, and still nothing works. The cells in yellow actually have a number, but it is not showing up. Any ideas?
-
Failed to convert value '(137.790)' from type string to type floating point
Any idea how to fix this error? It seems that my columns are a floating point, so not sure what the fix needs to be.
-
Dataflow was saved, but could not run?
Does anyone know why I would this error when updated my ETL? I update this report each week, and received this error. I even defaulted to reports that have worked in the past. Is Domo having any issues today?
