-
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?
-
Floating Decimal
I am trying to connect to data sets together, but I continue to get the message of remove 1 column, Budget DH TTH: Floating Decimal, after run the preview, but in my preview, I see there is a floating decimal. I also try to add it in the alter columns, but it still doesn't fix it. Any ideas?
-
How do you get rid of the max, avg and min in a chart
