-
Updating Datasets
Hello, My datasets were moved to a different server and now I need to point all my dataflows/cards to the new dataset. Before I do can someone please guide me with the following questions: Is there a way to change the datasets in one place vs going thru each dataflow? My predecessor applied some of the beast modes to the…
-
HTML Table Hyperlink Beast Mode
Hi, I am trying to find a way to add a hyperlink to my HTML Table where I have a Column called 'ID' with rows of numeric values of our Helpdesk Case #'s. How do I create a beast mode formula to link to our helpdesk system: If ID = 12345 and link is https://www.helpdesksystem.com/userui/ticket?ID=12345 Thank you in advance!
-
Shopping Funnel Via Google Analytics Advance Connector
Hey, The business question I’m trying to answer is where customers are dropping off in the purchase funnel. I tried using Google analytics advance connector, but the data does not align with what I'm seeing in the platform or what I see in my other datasets that use the same connector. Have any of you guys successfully…
-
CONCAT different cells in the same column
Hello I have a column let's says its called 'Column A' and it looks like this: COLUMN A 1 2 3 4 How do I concat so It shows in the same column like so: COLUMN A 1,2,3,4 Is there a beast mode that can help me do that? Thanks!
-
How to find the difference between 2 dates?
My dataset aggregate value totals on a monthly basis. Each row represents an individual site and value for numerous metrics. What I am trying to do would be how to find the change between 2 months like between Oct 1 , and Nov 1, as shown above for the values in the column to the right. But I am not sure how to write the…
-
How to find a two digit number in Replace Text
I'm using replace text to change Country ID codes with the name of the country but I find out that when the the text code is "10" it just read the last number and replace it. What should be the right configuration to search the whole text?
-
Dataflow creation best practice and recommendation
A lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an easy 1:1 comparison that makes joining the data very easy. usually I am using 1 report for almost the entire visualization, and puling a column or two form the 2nd report. Since the reports aren't in an identical format, and…
-
Formula to Remove Duplicates and keep Max Value
Hi, I am currently looking at some records where customer's accounts were waived. However a customer can have two applications waived the same day (maybe they drew on the account two different times so there are two applications on an account for them.) I want to remove the duplicate record and keep the record showing the…
-
Period to date sales beast mode
Currently using this beast mode for "this year period to date sales": SUM(CASE WHEN `SALE_DATE` > CURDATE()-40 AND (CASE WHEN CURDATE()-1 >= '12/30/2018' AND CURDATE()-1 <= '1/26/2019' THEN 1 WHEN CURDATE()-1 >= '1/27/2019' AND CURDATE()-1 <= '2/23/2019' THEN 2 WHEN CURDATE()-1 >= '2/24/2019' AND CURDATE()-1 <= '3/30/2019'…
-
Conditionally Format Data Label Fill Color on Grouped Bar + Line Chart
Hello, Is there a way to conditionally format the data label fills below so that any positive % has a green box with a white font & any negative number has a red box with a white font? I have seen success in similar situations in Domo where others have used HTML statements within beast modes to achieve a similar result,…
-
Creating a calculated column in beast mode results in data being split up
Hi all - I am new to Domo and experiencing some issues displaying desired results in a bullet chart. I have a beast mode calculation where it provides a value if one criteria is met, and another when a different criteria is met. In my bullet bar graph, when I select both criterias in the filters, values are now split into…
-
Can PDPs be created on other Admins?
I need to create a PDP on two datasets where admins only see the data that pertains to them. Is this possible?
-
FInd out who deleted a Dataset
Is there a way to find out who deleted a dataset in DOMO? Thanks
-
Join Function in ETL
Hi, I am trying to join a table on my DataSet, using the left join function. My original DataSet contains only 118k rows, and the other table contains 1405 rows. I thought that the output DataSet will stay 118k rows, and just have addition columns on it. However, the output DataSet is 4.6M which is way more then I…
-
Putting Current day and Previous day as columns instead of rows
Hello! I have run into a problem just like this link: I followed the sql transform but once I ran it the output dataset was the same as the input dataset. I don't know what I am doing wrong, I even uploaded a file that is exact to the example in the link above. If someone can help me figure out why it seems like its not…
-
Dataset Views: Best Practice to Remove Duplicates?
I'm still wrestling with this topic... finding the best approach. Any suggestions?
-
How to split values from one column in to 2 columns?
I have a column that contains values that are 4 digits. I want to divide them up in to 2 separate columns. The first 2 number are the % of the discount, and the last 2 are the length Ideally it would be the % and contain 30, 40, 35, 40 ,etc... Then Length would have the last for digits like 02, 02, 03, 02, 04, etc.. I am…
-
Converting Week Numbers to Dates for custom week date range (Monday - Sunday)
Currently, I am using the DOMO out of the box solution for converting week numbers to dates. This works great for a Sunday to Saturday week; however, a request is being made to view our week as Monday - Sunday. I have attempted DATE_ADD and WEEK variations but have been unsuccessful. Here is my current Beast Mode:…
-
Change column data type
I have a column with a date as a string, example 01/01/21. I want to convert to a date. I attempted using string to date and date format in Magic ETL 2.0, but I got an error message saying that it couldn't parse the text field to date. Then I tried the alter column tile, which also threw an error. I turned off Magic ETL…
-
Issues with FB Advanced Connector
We've been using the FB advance connector and was smooth sailing until mid-July where It looks like DOMO and FB API was having some issues preventing data to load. It looks like those issues have been resolved but I’m having issues retrieving data from those days where the Data issues was occurring. Does anyone have any…
-
Average of a calculated field that divides two columns
Hi, I have a calculated field that divides two columns for each row. We can call this calculated field 'row total' : SUM(`Total A`) / NULLIF(SUM(`Total B`),0) I am trying to get the overall average of all the Row Totals: avg(NULLIF(`Total Views`, 0) / NULLIF(`Total Conversions`,0)) I have been checking the dataset and…
-
ETL setup - duplication breaking calculations
Hi, I'm making a dataset where the concept is to take staff's login and logout times and figure their logged in hours per day. Then, we want to know certain measures based on their hours logged in. So, in ETL, I've gotten their total logged in hours per day to one row, grouped by the date and the staff member. Then, group…
-
Using latest record for daily monitoring
Hi, So in a credit customer database, I basically have two tables: Customer/portfolio table -> this would record daily update of portfolio movement (outstanding amount, fees, days past due, etc.) Credit limit usage table -> this would record changes in customer's credit limit utilization, meaning it would get updated only…
-
How to show a zero while filtering dates
Hello, I'm filtering previous week and I need every floorplan to show based on how many leases are signed even if it is blank. It is currently showing only two floorplans with a total of 3 leases signed. How do I show all floorplans and if not leases are signed I need it to show a zero?
-
Creating a Custom Segment of a Clustered Bar Chart
Hello, With the recent update which added segments I was wondering if it is now possible to add custom segments of a clustered bar chart. For example, with the chart below I have YoY sales by week, but filtered to only show week 16-28: I see in the segments tool that it is possible to create segments which ignore filters,…
-
Issues with the Instagram Connector ,can't connect?
We've been having issues trying to connect the instagram business connector. We keep receiving error messages when we try to connect to the instagram account even though we have all the credentials. Has anyone been able to connect with this? This is for organic Instagram insights.
-
Alert Error on Dataset
Hey all, some of the alerts we set up are getting this error: 2 or more rows have duplicate values in columns designated to track unique rows We have unique row values but they keep breaking giving the above error. Any suggestions how to fix this? Thanks!
-
Split Full name into First Middle and Last
I am looking for a good way to split a full name into First Middle and Last. What is the best way to go about this. Examples of possible name formats Doe, John Doe, John M Doe, Joe James Doe, John Henry Doe-Kahn, John Aba Doe, John
-
How to delete portion of text in a column in the ETL?
I have a date column that is in this format: The format of the date is fine, but what I am trying to do is get rid of everything including the 'T' and to the right, so that all that is left would be 2021-06-27. If a solution within the ETL is possible that would be great.
-
Creating a Beast Mode for a Tooltip to Compare Data from one Column to Another
Hello, I have a card that is used to display YoY growth per week for a market. My setup is as follows: -A clustered bar chart with symbols -Week # is the x axis -LY & TY Dollars is the y axis -YoY Growth % are the symbols which are connected to a secondary axis. The chart looks great and is displaying everything correctly,…