-
Applying Filter Tile to Remove Nulls Not Working
Any ideas as to why this isn't happening?
-
Capturing a calculation and add the result to a new dataset.
Hello everyone, I am seeking to compute the present amount of accounts receivable at the end of each month and integrate it into a dataset. This will enable us to analyze the fluctuations in these figures on a monthly or yearly basis. However, I'm unsure about the process of capturing this output and creating a separate…
-
Multiple case statements
I have 3 columns in a table with with fruit name , benchmark value and achieved benchmark value. Ideally I would like to use colors on a table when (in this example) : Apple is equal or greater than Apple benchmark value then Green, else Red Orange is equal or greater than Orange benchmark value then Green, else Red Pear…
-
Inline Line Editing Structure
Hello, I am trying to use inline editing to make changes to a dataset by labeling a line item 'YES' or 'NO'. The data I receive is replaced each morning (Some line items are updated, some are removed, some stay the same. ) Currently any changes I make today to the data will be erased the next morning. I have tried doing a…
-
Need help creating Formula to select Invoice Number when it Contains an "A"
I need help writing a Formula for an Aggregated Field in a Group by that will select the Latest Invoice that has an "A" in it if it exists. This example only has 1 Credit and Adjustment (C & A Invoice but I could have multiple to I need to take into consideration the Last Invoice Date as well) Below is my attempt but I…
-
ETL output to Google Workspace
I have one department who just need an ETL tool with no dashboards eg. I know I can get files from google Workspace, do the ETL magic to them - but then can the output be back to Google workspace?
-
Prioritize one set of data over a duplicate set of data, when available.
I have similar data coming in from two different sources. I need to make sure that when dataset A is available, it is used, and when A is not available, B is used. I want to end up with one row of data per day per website, but I either end up with only one day's worth of data per website (Hostname in my data), or I end up…
-
Having Multiple Group By tiles?
I am looking to have two separate groupings in one ETL. Is there a way to do this without having to use two Group By tiles? Also I no longer see the minimum aggregate option for my new column. Do I now have to use the Min() formula?
-
New Dataflow Run Options
Looks like Domo has silently updated trigger options for dataflows (hopefully its not silent and they tell people, I think it just got to my instance about an hour ago so hoping I am just early and more details will come out soon). I love this idea but do feel it is a bit clunky and requires a lot more clicks but I need to…
-
Need Rank to update in non-standard (?) way
I've got customer records with customer GUIDs, record dates, and member status. If the data for a specific customer looks like this: Date Status 1/1/2023 Active 2/1/2023 Active 3/1/2023 Inactive 4/1/2023 Inactive 5/1/2023 Active 6/1/2023 Active 7/1/2023 Active I want to get a dense ranking that groups the status together,…
-
Issues with changing cast dataset to date
Hi! I am trying to change the data created column to date, but when I check append rows, it says the column is changing to timestamp. I am not sure what I am doing wrong.
-
routing ETL failures through zapier
Is it possible to send ETL failure messages to Slack using Zapier or a similar service?
-
Forcasting Data by Zip for a 24 month period
I am looking to forecast mover data out 12 months looking at a 24 month period of historical data for each zip code in the US. Currently we run this with a spreadsheet and a forcasting formula. Looking for anyone who might have done this before or has any ideas how this can be done in Domo. Open to other tools other than…
-
Can I see the basic dataset length between different steps of an etl flow?
For example, I want to know how many rows are in the table before and after a pivot.
-
Date Formatting in Tables/Charts
Hello, I am new to domo so hoping this is pretty basic to update. My date columns come in the following format "Jan 23, 2024" in my raw data. When I pick my date fields in any cards it only shows the year 2024. In some cases I will want columns or rows to be months or possibly days or weeks. How am I able to pull other…
-
Appended datasets, output displays alternative blended datasets
I appended 5+ datasets, technically I should have all rows appended one another the other without overlapping. Some of my rows in the appended dataset looks overlapped with the rows from other datasets. what could be the possible reason for this?
-
Change Number format in dynamic concat statement
I have create a concat statement to dynamically highlight a certain metric. Essentially it changes as the time period and other categories change. The number is showing in the format in the above picture and I am hoping I could abbreviate in Billion or at least show the number in account format. I would really appreciate…
-
How to reduce Magic ETL run time
Hi Everyone. I'm looking for a way to reduce the run time of Magic ETL 2 data flows. The ETL takes about 3 hours 30 minutes to run I'm working with several left joins and formulas in sequence on about 12 datasets of 10k rows each which generates an output of 30k rows. Beyond this, the ETL performs no other complex…
-
How do I search for rows containing specific text and replace the information in that row?
I have a column in my ETL dataset that is named "City", in that column there are multiple city names however they have been put in in all different ways (ie: st george, St. George, ST George). I would like to search that column for rows containing 'george' and replace the information in that row with 'St. George'. I've…
-
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?
-
Isolate email addresses from a column using Magic ETL or BeastMode
Hello, I am trying to isolate email addresses from an Information column in a Dataset. A sample of the data from the column would be something like 'someone's name [email@email.com]' I don't necessarily need the name part, but I do need the Email Addresses, which are always bracketed in this column by '[]'. I am using a…
-
YOY in table card beast mode
How can i display YOY Sales Data side by side in table card using beast mode. I am using this beast mode to display LY Case when year(DATE_SUB(CURDATE(), interval 1 year)) = year(`Date`) then `Net Sales` end and date selected in table card is This Month
-
Nested Case and Concat Statement
Hi, I am trying to figure out how to create an Etl that expresses: If a particular year has a result then concat that with another column's result. Something like: CONCAT(case WHEN 2015= 1 then '2015', '-', Virtual vs In-Person else '' end) 2015 has a 1/0 constant and I want the result to be if they attended in person (so…
-
BEAST MODE CALCULATION ISSUE
Using the Beast Mode below I am being forced to use the ABS function in order for the Beast mode to give me a calculation. If I remove the ABS Function I get the error "An issue has occurred during processing. We are unable to complete the request at this time". The issue I have is I need to remove the ABS (Absolute Value…
-
Data Processing using Partition
Why I am having data loss issue when using data partition in Domo ETL?
-
Trying to use Unpivot
I have a dataset. 1 order has 10 stages. each stage has a schedule date, completed date and status. 1 order has 1 row and 30 columns. I am trying to unpivot to 1 order having 10 rows and 6 columns. I used 3 different unpivot tiles for it. I built out the ETL but not sure why its taking forever to run.
-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
how to combine mutiple rows into one separated by ','? Form builder muti selection data handling
I used form builder and there are couple fields are multisection dropdowns, in the response dataset, it separates the selections into different rows, but I want them to show as a,b,c together not a(next row), b(next row),c. Does anybody know how should I use the magic ETL to do that? I used my old way to transform the…
-
Renaming Columns and NOT breaking cards
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
-
ETL calculation to work out hours taken from a start and finish timestamp
Hi all and happy Monday I have some data i am pulling in via a SQL workbench that gives us a time clocked onto a job and another column for clocked off the job. The data is in a the format 2022-12-23T14:27:20. So i am trying to generate a calculated column that gives me the hours taken per job, for example: Clock on =…