-
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…
-
$ Amount
I am using a Sales Funnel chart. When I have a dollar amount such as $12,363.12, the amount is omitted from the total. If I load it with just $12,363 it will show up. How can I still get a total with having the cents included? I have tried floating and fixed decimal both.
-
Scheduling Excel Reports
When I send this report as an Excel attachment, it comes as a CSV. Can scheduled reports be sent as an Excel format not CSV?
-
I am using the email connector, but I am getting an error.
Domo is ready, but an email was received that did not pass the regex filters and was not processed. Invalid Body regex. I have used an email connector before with some automation, but I am trying to send to the email myself and get an error. Any ideas?
-
Is there a beast mode I can use to add two columns and then get the average?
-
Avg Function
I am trying to find an avg over a 4 week period by using dimensions (text field.) Is this possible? I can get a count, but there isn't an option for avg.
-
Dimensions and Measures
Hi, Is there a way to use a dimension field also as a measure? Similar to what you do in Excel while using a pivot table?
-
PowerPoint
Hi. Is there a way to add a PowerPoint Template to a dashboard?
