-
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?
-
Why would I get an error "failed to parse text BATCH ID from column End Date New as type Date?
Every quarter I am adding a new budget file, and when I am adding Q3, I get this error. This did not happen for Q1 and Q2. The file I am adding does not have a BATCH ID column, but I do have an email connector set up to receive a weekly file for the actual data, that does have a BATCH ID. I know this one might be hard to…
-
How do I change a field that is a text to a number?
I am trying to change a field that shows up as a text field to a number, but I am getting the below error in magic ETL. Any ideas on how to change this field to a number?
-
Can you import multiple tabs in an excel document using the email connector?
I have a file/data set that is updated weekly by using an email connector. Is there a way the file can have multiple tabs at the bottom and have all tabs imported?
-
How can I add a new date column to an existing data set?
I bring a sales data set weekly, and started this about 6 weeks ago. This week my file had a new date column, but the new date column is not visible when I want to add to a card on my dashboard. I am assuming it is due to the past files not having this column. Anything I can do besides re-adding all the past files with the…
