-
Datediff per month
Hi, How can I show the datediff per month instead of per day. I tried the following beastmode: DATEDIFF(`date1`,`date2`,MONTH()) Can someone point me out what I am missing? Thanks in advance
-
Data Warehouse Summary Values
Can someone tell me what is counted as 'DOMO MAGIC DATA' in the summary metrics shown in the top right of the data warehouse screen? I've read the documentation on the Data Warehouse page and watched the little video but it doesn't specify what that is counting. I originally thought it was dataflows so I created a test…
-
Beast Mode Validated but not working
Hi all! My beastmode here is validated but it shows a message "An issue has occurred during processing. We are unable to complete the request at this time. " This is my beastmode: SUM(`Real Produksi TBS Tanaman Produktif (ton)`) / (SUM((`RKAP Luas TM (ha)`) / (COUNT(DISTINCT `Date`)))) So basically the context is: "Real…
-
Simple Addition and Subtraction
Hi There, I am having trouble in returning correct values with a simple addition and subtraction beast mode. It appears that any column with a blank value will not return a end value. And any row with values in all columns calculates properly. Any suggestions on how to calculate to consider blank values as zero value?…
-
Deleting a batch
I have 2 batches in a dataset that need to be deleted. The batches are easy to identify and the 2 just need to be wiped out entirely. I am wondering if it is possible to just go in a delete a batch, and what would be the best way to do this?
-
Formula failing to convert value from a type string to a type date
I think I need some help with the order of operations on this. I have recursive dataflow for Yelp data. I am trying to create a 'metric date' column by 1st, Splitting the ' FILE_NAME' column date example 'security_public_storage_account_time_range_report_11_1_2021_to_11_30_2021.xls Then in the next Tile I am using the Add…
-
Turnover calculation query
The assistance from the community was great and I have been exploring Domo. This request is in continuation with this data set https://dojo.domo.com/discussion/comment/55564#Comment_55564 Based on the turnover calculation in the excel file, I would like to get some guidance on whether it can be done on the beast mode or…
-
Data Table no thousands separator
I am importing case data from Salesforce. The case number always comes in with thousands separator. Is there any place where I can default to just give the number without the separators? Best would be directly upon import. Or then later in the ETL. Thanks for any ideas! Caroline
-
How to fix different number formatting - thousands separator
In my ETL preview, I see the field Case Number as I want it, without Thousands Separator. When I then Run and check the actual Data table or drill in Cards, then the Thousands Separator is there again. Where can I change this setting? I would like to be able to copy the Case Number and paste it in the Search of Salesforce.…
-
How to output list which can't be joined
Hello, I would like to know how to output list which can't be joined. I would like to join two list as below with "Product". My ETL is below. I could join the data. I would like to make one more output as below data. "grape" in Product in left list is not existed in right list. So I would like to output this data as well.…
-
Is Magic ETL 2.0 able to handle more complex SQL injections?
Alright guys, I feel like I am going crazy. I have a beast mode card that works really well in calculating months on hand inventory. I am now trying to create an new ETL that does a group by vendor and I am trying to inject the same code. The issue is that 'Available Inventory' is always returning null for some reason. Is…
-
Map Only Certain Values from One Column to Another Column
Hi, I have 2 columns. Column A has one set of values - I only want the value of Column B changed if the Column A value = Complete. Example Progress Column A ------Progress Column B ------Result Progress B Completed --------Started ------ Completed Started ------ Completed ----- Completed Started ------ Started ------…
-
Help on recursive dataflow
I have a recursive dataflow that keeps getting hung up from an issue on the join between the recursiveprod and the main data that is being groupby. The error it is showing is DUPLICATE COLUMN NAMES. So I go and change the column name and i am able to get it to run. it then takes that new unique column name and adds back in…
-
Need Ideas/Help for Creating a Card
There are orders (non-unique) that can have multiple services assigned to them and can also have different vendors assigned. Trying to identify a way in Domo to weed out some orders that fit these criteria: If an order has 2 or more services under the same order number and if the order has at least one service code ‘GB’…
-
Convert String To Date Format
Hello, I'm working in Magic ETL. I have two problems 1 I have a Hire Date field with a string data type that has the string in 2 different formats 01/01/19 or 01/01/2019 How can I convert the values to one format? 2 How can I convert the standardized string to a date. I tried to use str to date but it failed each time.
-
Is there a way to check if a field has more characters than a specific amount?
Hi! I am trying to set up a beast mode function that checks if fields are correctly filled out in our asset tracking software, and lists out any asset that does not meet all requirements (ie fields not filled out or have been auto-generated by the software itself). One thing I am curious about is, I'd like to be able to…
-
How to reactivate a dataflow disabled from inactivity?
I have a fairly comprehensive dataflow. Most of the datasets that are a part of this dataflow update nightly, but there are some others that only get updated monthly due to limitations in how we get the data then how it gets in to Domo. We use the email connector and when we receive the statement once a month email it via…
-
Seasonality Chart
Hello, I am trying to create a Card that will help with the forecasting. We receive cases (CasesID) by Regions all year, I need to create a Card that will show all the regions and then the month as columns, the values will be all the cases submitted in that month / the total cases submitted from that region. Where I am…
-
Foreign Currency Conversion Help
I have a dataset that has amount coming in as "Euro", which I would like to convert to "USD". Does anyone know how to go about this in magic ETL? Preferable I would like to use my own fx rates which as you know is likely to change per month. Is these case statement or other that I can use to get this done please?
-
Need help getting pointed in the right direction for what might be causing inflating counts
I have a table that has details of inventory at each site that illustrates KPI's like Occupancy, vacancy, days vacant, and occupied units. It is put together using 3 different data sources. Price list - This is a majority of it. it is all the units aggregated row by row with those occupied, vacant, and total unit details.…
-
Converting Time zone with day light saving
Hello, I am trying to do a simple conversion of time zones of a datetime column from UTC to CST and EST. For some reason, I am getting error in this formula: CONVERT_TZ(`DateTimecolumn`, 'utc', 'cst') I also tried CDT instead of CST but getting error. I need something which works for time zone conversion as well as day…
-
Pivot Transformation in Magic ETL not Pulling in 4 columns? HELP
Aloha team: Data is coming from Survey monkey; therefore, I have to transform the data from rows to columns. I have 18 columns that I do this with; using one pivot transformation, since all the data is similar (i.e. #1, 2, & 5) (1st pic). The issue is 12 columns are able to transform the data, however, four (2nd pic) is…
-
Beast mode - Join data from another line
Hi Domo community, I would like to achieve a join from a single dataset. Here is the column I have : ID, Parent_ID, Parents_status, Comment 11 21 2 12 21 3 21 Done 1 I would like to do some beast mode to join data between lines and create two type of data: Extract the parents status to apply it to the ID in the column…
-
CountIf function in Domo
Hello I have a data that contains all the cases submitted and their submission date and in another column it has the approval date which can be in another date/year. I am trying to get the conversion rate (approvals/submissions) for each month, because of the timing they might not happen in the same month. A pivot table…
-
The correct regex to remove the first character?
I have a column( that illustrates a dollar amount but is in string format. What I am trying to do is to remove the dollar sign ($) that is the very first character in each row, so i am only left with the numbers. I have tried the left/right substring but each dollar amount is different length so I have ran in to issues.
-
Some content is too tall to export
Trying to export a dashboard with lots of cards to a PDF. The PPT download won't hold dashboard filters when exported. The email scheduled report does not send the entire dashboard only part of it. What are users doing as a workaround for exporting reports to external (non-domo) users. This is all robust financial…
-
Write a Filter Formula using Magic ETL Filter Tile
Hey guys, so I am trying to utilize the filter formula feature in magic etl, but I can't seem to get it to work. When I run the following formula, no data appears. Using Excel, I performed a concatenate on all 517 websites that I would like to be filtered out from my data in order to build my formula. I've also used AND as…
-
ETL join is matching multiple values - not exact matches
I am joining two datasets and the result is matching multiple values from the second data set to a single value in the first data set. Is it possible to have the join only match exact values? Example: Data Set 1 Data Set 2 Join result Join = Left Outer Left Table = Data Set 1 Right Table = Data Set 2 Matching Column = ID…
-
DOMO - Timestamp
Hello, I have data coming in from SQL with a timestamp from previous day. So the date in the table will be current date -1. I want to separate this data into 3 different tables, Table 1 - 7 AM to 3 PM Table 2 - 3 Pm - 11 PM Table 3 - 11 PM to 7 AM. How can I add a formula in the filter for tile to filter the rows by that?…
-
how to show a duplicate in a table graph
Hello Dojo! basically, we have a dataset that shows the number of beast modes we have created along the years. what we have is one column for the beast mode name, who made it and when. what we do not have, and what we want is a column that identifies that this beast mode is a duplicate. It would either show "1" or…