-
Newly created dataflow getting failed with error message "Unable to update to Dataset"
Hi Team, I am facing one issue from yesterday i.e., Dataflow getting failed with error message "Unable to update to Dataset". I have created this dataflow yesterday and try to run it many times with different logic but it is getting failed every time with error at "Output Datasets" step. Even, I have created two more…
-
User retention Beast Mode Help
Hello, I'm looking at my dataset on our platform users and am trying to make a domo card that shows the "quick ratio" for each month, which is (New + Reactivated) / Churn. My dataset has the following columns: Month / Active Users / New Users / Reactivated Users For example for Month 2, Churn is found by: Month 1 Active…
-
Combining values in 3 columns into 1 new column
I have 3 columns of dates (for example purchase date of: Column 1 - Apple , Column 2 - Pears, Column 3 - oranges). I want to create a new column that combines all 3 of these column dates to display a single column of dates. This is to be used for another set of data analysis (where the date is important and needs to be…
-
Rounding a date/time field to the nearest half hour
We have a date/time field that I'd like to accomplish the following with: * Split the date and time into two separate columns (while also maintaining the original column) * Round the time down to the nearest half hour increment (for instance, 8:43 would round to 8:30, 8:18 would round to 8:00, etc.) Issues to be…
-
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
-
Excluding weekends (using DATEDIFF function to identify employees first 3 days as training)
A search for Exclude Weekends and Exclude Weekends using DateDiff Function returned a few results, none of which would seem to work for what we're trying to do so checking to see if we can get some help on this! We're trying to add, in the dataflow itself, as part of the output dataset, a transform that would add a new…
-
Beast Mode for Count Distinct with Condition
I want to get count of values in a column based on a condition for another column: Example: Count(Distinct 'visitor_id' ) where visitor_called = 'Y' The above give me a syntax error. Trying with 'Case': (CASE WHEN `visitor_called` = 'Y' then COUNT(DISTINCT `visitor_id`) else '0' END ) This returns me overall counf for…
-
How to map 1 value into the same row of another column in ETL
Please see attachment. I need to map a value from one column to another. Context: Marketing's Department ID needs to be the same as its Organization ID. I've tried Value Mapper but it seems like that will only allow me to make a brand new column. I don't want a brand new column. Please help! Which ETL function should I use?
-
ETL Actions: Edit Columns: Set Column Type
As stated in the knowledge base (https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns), the definition for the Data Type "Decimal (Fixed)" reads as follows: "Contains decimal numbers with a fixed number of digits after the decimal point". The definition does little to clarify the…
-
MoM formula in table card
Hi, I trying to create a table chart for keyword rankings. The chart will have 3 columns: Keyword, Rank(Last Month), Rank Change (MoM). I am having trouble showing this in a table chart format. If the table is only supposed to show last month's Position, it filters out other dates - so how would the Rank Change MoM be…
-
Python Node giving throwing up an error I don't understand
When I try to run my python script, it throws this error: Traceback (most recent call last): File "<stdin>", line 7, in <module> File "/home/domo/domomagic/io.py", line 17, in read_dataframe return pd.DataFrame(read_array_dict(input_name)) File "/home/domo/domomagic/io.py", line 26, in read_array_dict…
-
Issues making my calculated field work
case when ((SUM(CASE when `Activity Date`>=CURDATE()-28 then `Score` end))/(SUM(CASE when `Activity Date`>=CURDATE()-180 then `Score` end))*100)>=50 and (SUM(CASE when `Activity Date`>=CURDATE()-180 then `Score` end))/ 307>=0.5 then COUNT(`Account`)end what am i doing wrong to make this work. It is not coming up as an…
-
How can I get each x axis point to be a percentage of the total?
I'm having trouble getting units as a percentage of a total. I have a Y coaxis "Views" for example, and an X axis with Dates, and each date has a specific amount of views. I want each date to show as a percentage of the total views within the date range on my X axis. If anyone could help that would be great. Thanks!!
-
Beast mode - Calculate how many rows per individual
Is there a way for me to create a beast mode calculation to return how many rows there are for each individual? For example, the data would have: Employee ID Employee Training Completed Completion Date 123 Joe Welcome to Company ABC 2/5/19 123 Joe How to use DOMO 3/9/19 222 Mary Welcome to Company ABC 4/8/19 The beast mode…
-
Help Creating New Column From Summing Another Column
Hello, What I am trying to do seems pretty straighforward, but due to my lack of knowledge/experience, I am having a hard time getting it. I have card that displays the total contract value of of projects assigned to a particular project manager/employee for a given time period. My goal is to create a new column that…
-
count states in rows
Have a series of rows of orders for different states ex. order state 1 CA 2 CO 3 CA 4 MT i.e. the count for CA would be 2 and CO, and MT would be one, assuming would need to do sometime of grouping? But how do I display the count total on the card? thanks
-
showing the number of rows in ETL preview
Hi All, I want to see the number of rows in each step of a flow created in Magic ETL. The purpose is to compare easily, ensuring my transformations are doing as I expect. thanks, Richard
-
Using a 'Created Date' as a series Parameter
Hey everyone, I'm trying to find out if it's possible to use the created date of thousands of leads, and group them into 'Quarter 1', 'Quarter 2', etc. etc.; and use that grouping as a series to group data by? I have a 'Created Date' field which is in a standard long date format. my Fiscal year starts on 2/1, and i already…
-
Create a Histogram with More Buckets
Domo's histogram card currently only allows a maximum of 20 buckets which may not be enough. How do i create a histogram with 1000 buckets?
-
Is there a good solution to reference "date closest to"?
I am trying to reference snapshot data from ~8 weeks ago (or ~60 days, or 2 months, any of these would work), and we only snapshot this particular dataset once a week. So I am needing a formula in MySQL or Beast Mode that references the snapshot date closest to 8 weeks ago so I can pull in a field and compare to what the…
-
Connecting Multiple Accounts from a given Social Media Site
Recently started with Domo and need to connect 19 different accounts to it. Am wondering on the best way to connect the 1 Website, 16 Facebook Acccounts, 5 Instagram Accounts, 18 Youtube Accounts, and 5 Pinterest Accounts. I understand that using the apps would work but am trying to streamline the process so that I could…
-
How can I prevent data being filtered if I graph by period
I have discovered that Domo is filtering my data if I choose to Graph by Year. This produces a problem because I need to reflect an accurante summary number. It only appears to happen when I graph by YEAR, Month, Quarter, etc. and I'm using a Date field in the X-axis. To convey this, I will use an example: I have 100 rows…
-
Magic ETL doing regex_like: making a text column numeric and all non numeric values set to -1
Hi all, I am looking to transform data in Domo which is a mix of numbers and alphabet characters and am trying to create a new column using an operation similar to Oracle's regex_like function and a case statement. I can do this in SQL, but would like to know if Magic ETL can do something similar. With the example below,…
-
Custom Chart - Customizing the Legend Values / Displayed Names
I have a custom chart that lists all the counties in our state. When applying the custom chart to data, the legend populates the values. I want the legend to populate the names. Can this be achieved? The first photo shows how the legend is showing counts of the FIPS (counties) values. The second photo shows an example of…
-
Pulling latest 4 weeks from Max date in Beastmode
Hello All - I'm trying to create a filter for the latest 4, 13, 26, and 52 weeks so I can pull sales by these time frames. I'm not trying to pull from the current date, but from the max date that is available because our reporting only comes in every 4 weeks. This is my current query that is only returning 'other'. CASE…
-
Beast mode to count number of occurrences within a time period
I'm new to Domo. I have a business request to count the number of instances when an event occurred more than once in a given date filter. Example: Event X happened 5 times in the selected date range, Event Y happened 4 times in the date range, and Event Z happened 1 time in the selected date range. The count for the date…
-
Calculating the total of a column
trying to calculate the percentage of the total for each row in Beast mode. the formulas I have found don't work, because the SUM function only takes one single value per row instead of aggregating all of them. The percentage for each row is 100%. What formula should I use to get a total for all the values under a single…
-
Filter Removes Summary Number
I created the following beastmode for my summary number. The beastmode works and returns the summary I am looking for. However, when I change the filter on the dashboard (ie to look at a specific customer instead of all encompassing) the summary number on my card turns to zero. Any ideas how I can get my summary number to…
-
Add List-Items to a single table card cell
I have an Asana API pulling in project status field. The incoming values are unordered lists <UL><LI>. Is there anything that I can do from a beast mode perspective to maintain this formating versus (adding line breaks & bullet points, etc.). Ive seen suggestions on Dojo that included a REPLACE() but that still formats…
-
Dataflow Run Control - Execute on 1st of month only
I have a large dataset that is refreshed on a daily basis. I have cards, however, that I would like to stay static during the month and only reflect the end-of-month value(s). I could: * create another workbench job to upload a second version of the data based on a different schedule * I could create a manually executed…