-
Finding the latest date with specific criteria
I work in the training area at my organization. We are trying to determine "What is the latest date they have completed all of their required training?" For example, a new agent comes in, and they are assigned Program A, Program B, and Program C. We want to know what the latest completion date is when they have completed…
-
MySQL query for YTD Running Total
Hi all, I'm having trouble creating a mySQL query that does a running total by a certain Group By dimensions. Here is a sample structure of the data: datestoreChannelVisitsYTD…
-
Role Permission needed for PDP Use
What permission is needed for a user to use PDP on a data flow? Our users do not have Can Manage Data Set or Data Flow because we update and manage them on their behalf. Is that what is needed to use PDP?
-
Surveys in specific Date Range
Good morning, I currently have a dataset being created from our Qualtrics connector that counts the number of surveys and averages scores from specifi questions in a given time period. The time period we go off of would be between the Last Day of the Quarter (Period End) and 180 days before the Last Day of the Quarter…
-
Magic ETL Efficiency
Hello, I have a simple Magic ETL that I use to filter a dataset from our company's source system to only show the latest version of each record. The dataflow finds the latest timestamp for each record, then uses an inner join on the record ID and timestamp to only include the most recent row. I've attached a screenshot of…
-
Floating integers / Floating decimals, rounding
How does DOMO's version of MySQL handle floating integers when rounding? I went to round a field in my Dataflow. So that I could avoid changing 50 cards and removing the decimals in this feild. Round(`Trans`,0) When aggregated in the card I am showing my total trans is far lower than it should be. opposed to a bit higher…
-
Beast Mode Manager Tab
Hi, I was reading an article about the Beast Manager tab (https://knowledge.domo.com/Welcome/Domo_User_Interface/Data_Center_Layout_(with_Beast_Mode_Manager)#Beast_Mode_Manager_tab). But when I am looking in my Data Center I cannot see it. Do you have any idea how to access it? Thanks!
-
FB Ad Creatives - Images in cards
Hey all, We are trying to make a table card and display the ad creatives for our FB ads, images in the table card. I have brought images into DOMO before however we are trying to find a configuration of the FB ads advanced connector that can do this. Is there any way to bring in the URL with the existing connectors?…
-
Beast Mode in Pivot Table beta
Hi All! I created a card using one of the new pivot table options. When I use a beast mode in the table it does not seem to be able to calculate the sub-total correctly. My beast mode is a simply divide field A by field B. Does anyone have a work around/solution for this issue that can be resolved in the card itself? Thanks
-
Actual Data to Budget Data
We have created a data fusion where we have actual metrics. Example count of registered donors in fiscal week 14. In the data fusion we added budget data to say we budgeted to see x donors in fiscal week 14. We are now looking for a solution to be able to display the two together in a grouped bar chart. Any help is…
-
Change Column Name in a Dataset
Hi Guys, Is there a way to change the column name in a dataset? I'm using Informatica to load in my datasets into Domo. I know you can create an ETL flow but the dilemma I'm facing is: I have a dataset (Dataset_A1) which had 4 columns, account | record | id | amount_given I created a dataflow to edit the column names &…
-
Use ETL to make calculated column a measure
Hi there I had a measure of DELAY expressed in words in my input file. This cannot be changed by me. I used beast mode to create a new column with the word changed to a number and I called this column DELAY2 However, this column is still be treated as a dimension And if i open workflow to change this in ETL, the calculated…
-
Rounding Decimals in ETL, not in Beast Mode
Hi there, I'm working on ETL right now, I want to rounding a column which is in decimal. Our a goal is create a new Data Flow from few files, then from that Data Flow make some cards. So, is there any help us to rounding in ETL Transform ? Thanks.
-
ETL Transform - Free Trail Version
Hello Experts, I am new to DOMO and trying to explore ETL Transformation. I am using a simple replace transformation and getting the error
-
Converting a beastmode text field into a number field
Hello, I am struggling to get the values my beastmode returns to display in the correct format. To summarize, I'm looking at blood draw times for donors. The data comes into Domo as phlebotomy start time, and phlebotomy end time (which are both date fields). So, I made the…
-
Beastmode Trouble - Getting a unique count of 2 based on 2 columns in 1 row
Hello, In this scenario, each donation id is a unique value and is 1 row. Each donation id has 2 columns: HGB and HGB2. If HGB is not null, that means the donation id received an HGB stick. If HGB2 is not null, that means the donation id received a second stick. If the fields are null, the donation id recieved 0 sticks. In…
-
Case Statement Help - Condition not being passed
Hi All, I've been struggling with this absurd problem when creating a beast mode calculation using case statement. Basically I'm trying to pass 2 conditions into my case statement but for some reason, even after validating the formula, only 1 condition is passing. My calculation is: (CASE WHEN YEAR(`transaction_date`) =…
-
Providing a True/False(Y/N) if text in a comma separated string is in a separate column
Hello, I have data that looks like this and the goal is to validate if the order season is in the selling season. I tried like but it didn't seem to be consistent. Any help would be appreciated. Order SeasonSelling SeasonsGoal18SP18SP,18SU,18FA,19SPY19FA18SP,18SU,18FA,19SPN18FA18SP,18SU,18FA,19SPY20SP18SP,18SU,18FA,19SPN…
-
Regex to Only show data before a certain character
Hello, I have data that looks like this: line_items_nameGoalBanks Short | Navy Camo - Navy Camo / SBanks ShortsThe Rise The Shine Tee | Charcoal - Charcoal / LThe Rise The Shine TeesClassic Vuori Tee | Heather Grey - Heather Grey / SClassic Vuori Tees I want just the items to the left of the | to show. How can I achieve…
-
Adding up values based on a date range
In Beast mode how would I add up criteria in another column based on a date range? Refer to my attached picture: I would like to have a pie chart for 2019 and 2020 that adds up the various values based on a date range.
-
Time Zones
How do I change the time stamps in my postgresql data from UTC to EST? Saw the convert_tz() syntax from Domo but that's for mysql. Not sure where I should run this and how. Thanks!
-
How to create a Beast Mode calculation for fiscal year using a date field?
Hi All, I have a unique dilemma. I need to create a beast mode calculation to calculate our revenue for the latest fiscal year. I know I can just manually add the date filter criteria into the calculation or add a filter but the thing is the data is updated every day and we need the date filter criteria to be dynamic &…
-
Popular SQL Functions Missing in Domo
Domo, I saw a post from 5 years ago stating that SQL didn't have CAST or CONVERT. It's now 2020 and: * CAST doesn't even show up in the prompts * CONVERT does but doesn't work * ROUND is not even considered in the prompts. Please add these and other popular functions ASAP. It's painful these are not in there...Thank you.
-
Adding Varying Goals to tops of charts
Hi! We need assistance showcasing overall data in comparison to a goal. This goal will be different month to month and needs to have the ability to change. This is in beast mode and we would like to compare our actual opportunities to the goals we can set manually. Any help would be greatly appreciated.
-
Redshift order by
My first try at using Redshift. Trying to use ORDER BY and not getting the expected result. The output table should be sorted by column "a". Here are the steps: 1. Create tbl_data SELECT 3 as "a", 30 as "b" UNION ALL SELECT 3 as "a", 30 as "b" UNION ALL SELECT 2 as "a", 20 as "b" UNION ALL SELECT 2 as "a", 20 as "b" UNION…
-
Dividing with Multiple Beast Mode Functions
I have 2 formulas I am trying to divide into one another CASE WHEN `Action` = 'Lead' THEN SUM(`Unique Events`) END and CASE WHEN `Action` = 'Completion' THEN SUM(`Unique Events`) END Individually they work fine and result in 100000 and 50000 respectively. I need to divide Completions into Leads to determine my dropoff rate…
-
Magic ETL - string operations help
If i have an excel spreadsheet that contains the following column called file path: FilePathBUILDING\200303379 Files\Receipt20181213_20200107_133244.pdfBUILDING\200303379 Files\Receipt20181213_20200107_133309.pdfBUILDING\200410340 Files\HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdfBUILDING\29700587…
-
Calculating Date Time Stamps for duplicate ID's
I am tasked to create KPIs for how long it takes for an ID to sit in a specific status. Attached is a snippet of sample data for reference. The amount of days for the first "status change time' would be taken from the 'HRC Create date', or when the ID was created, the rest of the changes would be the difference between…
-
Quick Help
I keep getting a syntax error. What am I missing? CASE WHEN `invoice number` = 325940 THEN `customer code` = 'CS10003' ELSE `customer code` END
-
Anonymize a column of data
I would love to be able to convert or transform a column of data to anonymize it. For example, I have a clients data set that we use all the time but I would also like to be able to have the client column have a replica column where all the names are converted or anonymized. This way I can use the same data but keep the…