-
How to append monthly data?
Hello, Please let me ask how to append monthly data to accumulated data. I want to append monthly data using DataSet via Email Connector on the accumulated data from January to April. For example, I upload May data by using email connector in May, the output dataset will be for January-May data. However, after that I…
-
PDP Policy Simple Filter - don't see value in dropdown list
I am trying to filter by store number (Store No) for a particular PDP policy and I'm searching "8". The value is definitely in the dataset, but it does not appear in the dropdown list and I'm assuming this is due to some sort of limit on how many values can be displayed in it. Is there a keyword or phrase I can add to the…
-
Case Statement or Formula for creating a flag
I have to create a flag in a dataset where (IF columns A.a and B.a = A.b and B.b ) then I have to check cols A.c = B.c or A.d = B.d My Data is like Can someone help me in case statement. The one I have is not showing correct results. First two columns have to match to figure out discrepancies in next cols. If cols match it…
-
Can I make a period over period pivot table with a dynamic date range?
I had a need to create a pivot table that has our % change ( this year sales - last year sales / last year sales). I was able to create an ETL that accomplishes this for any date this year. I am able to filter any date this year (MTD, QTD, YTD, etc.) and a beast mode will take the above formula to calculate my % change. I…
-
Issue with dates in ETL
Hello everyone! So we use filters similar to this in Domo and noticed that for some reason all results are being returned. What is happening below is we apply a filter on the rule to only look at 'Y' results that should be only applications hired this year, but instead we receive everything. We are working through it on…
-
Data Overview
Dear Community. I am trying to get an overview what data we are currently importing to DOMO due to data privacy evaluation. There are a lot of Data Sources (54) and a huge amount of respective Data Flows (1.9K). My question is if there is a functionality or app supporting me with listing all data schemas/column names per…
-
Row Limit in Bar Chart
Hi, I have built a bar chart that counts the number of completed cards by Card Title. I limited the bar chart to return 25 rows. However, the results are not correct. Some of the cards have 1 completion are showing in the top 25 when there are 100's of cards that have more than 1 completion. How do i accurately get the 25…
-
Need help to show total of last 18 months for each month for last 12 months
Hi Experts, I need to display a chart for the total number of patients for the last 18 months for each month for the last 12 months. I need help in figuring out this visualization through beast mode since I do not where to start. I am new to domo and beast modes and will appreciate you all helping me out here. Thank you :)…
-
How to add pivoted value to new columns by Magic ETL
Hello, I would like to ask how to add pivot value to new column by Magic ETL. I prepared the table as follows which have value of product for 2021 Apr-Jun and previous year of same month. I want to add rows and columns highlighted in yellow as shown on the right table by Magic ETL. The rows that I want to add is 2021 Apr,…
-
Dynamics 365 Emails - From, To and CC
Hello everyone, I am trying to build a dataset based on emails coming from Dynamics CRM. I am using the right connector and I was able yo map pretty much all the fields I needed through joins with other entities. However, I am having trouble figuring out the From, To and CC fields and for emails they are quite relevant…
-
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.…