Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Transforming an ETL
Hello! I am trying to edit an ETL with three input datasets.. My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset. Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'. The request I received was to add a column onto one of our cards…
Make Dynamic Date/Time Functions Respond to the Company Time Zone
The dynamic date and time functions—such as CURRENT_DATE() and NOW()—are represented in UTC, regardless of the Company Time Zone in your Admin Settings. This creates a problem during the hours of the day when the UTC date and your company time zone's dates are unaligned. For instance, say you have a Beast Mode that uses…
Base64 Decoder
Would like to have Domo be able to decode a column with Base64 data to a JSON formatted column/file/dataset.
Exporting Dataset as CSV ignores the Round function
Hi, I have a dataset that I need to extract. In the ETL, I round the column to 2 decimal places. When I extract the data and open it in MSExcel, I see the 2 decimal places. However, if I open it in notepad, I see multiple decimal places. How can I avoid this to happen? Any advice would be appreciated. Thank you.
Beast Mode Function Parity in Views
There are a whole host of useful string and number based functions that exist in Magic ETL that do not exist in views. For example, I would like to use STR_DIGITS() in a calculated column to remove all letters from a string. This exists in Magic ETL but not in views. This seems like an oversight.
Removing Duplicates and making sure only the one with the most recent move in stays
I am working on an ETL where I am transforming some unit rental records. I am trying to only include the most recent rental for the unit not historical data but the input dataset includes historical data. When using the remove duplicates tile I do not have control over which ones are removed or added as they arent…
Views keeps converting time to UTC
Hi All, I am having an issue with a dataset. I am trying to extract an hourly occupancy from people's entry and exit dates and time. However, Views keeps converting the times from Eastern to UTC. I have checked, and my company's time zone is already set to Eastern. I'm not sure what to do from here. If I do an offset in a…
Logic - link original submit date to all subsequent back orders
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
Data storage
Hello, I understand any data coming from files and output datasets from DOMO ETLs shall store data in DOMO Cloud. Any of the following shall also store in DOMO Cloud? DataFlows SQL View (DOMO) Adrenaline Transform What if I use federated connection as my connector? or an API to retrieve data from source and leverage any of…
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.