-
CountDistinct Response Time in Seconds
Hi I am trying to produce a graph by month for tickets which have met my Response SLA. I have a Countdistinct already on ID as there are duplicates annoyingly but I have a field Response time in seconds and I want to work out which tickets have <=900 and which have >900. Response Time in Seconds is my field and ID is my…
-
Create a list of months between two dates
I have a dataset with two date columns: start_date and last_invoice_date for each client. I would like to generate a list of the months between these two dates (not the number of months, but the actual month names). For example, if I have: client start_date last_invoice_date A Mar 1, 2020 Jun 1, 2020 B January 10, 2018 May…
-
md5 or sha1 in beast mode
Does beast-mode support functions like md5 or any alternative?
-
Beast mode calculations not showing in the magic ETL
So we have this dataset with a lot calculations fields. I need to merge it to another dataset. But when I am doing magic ETL, I loss all the calculated fields. Any easy solution to this? The calculated fileds are showing when I am creating the cards but not on ETL. I don't want to add all the columns again. Thanks,
-
Data Flow Failed - Generic "There was a problem running this DataFlow " Message
I am getting a generic Failed message of "There was a problem running this DataFlow". I went in to edit the data flow and try to run preivew to and it says " Preview was unable to start. " The source data updates every 15 minutes which triggers the dataflow to run, but for some reason even thought the source data updated…
-
Domo is ready, but there is already an update storing. Please adjust your schedule to avoid update
Hello all, I noticed one of the datasets power a dataflow got stuck, while attempting to store data. I couldnt find a way to stop this dataset from attempting to store, I could however do another manual run attempt, however this would fail immediately as the dataset was still running and attempting to store data from the…
-
Append only missing rows
I have 2 datasets. I want to append the data togeather and keep all the lines from dataset A but only the lines from dataset B that are not represented in dataset A. I want to do this on a unique identifier. Any hints on how this would best be occoplished. See attached for an example.
-
"Schema is too wide for row" error in SQL transform
An SQL transform that I've had successfully running for months is suddenly giving me an error that reads "schema is too wide for row". There was an update made to the base dataset, but it was only removing a couple columns that weren't even being used. There's no further details regarding the error. Any ideas on what this…
-
alert if no datasets run on current day
Hi, i have 4 datasets which are supposed to be updated daily from API. we have some daily monitoring through domo stats that alert us in case of the number of datasets which are update is less than 4. But we notice if no datasets have been updated on the day then alert don't trigger as it has no data to track. I would like…
-
HTML link to External site Using Values in Table
Aloha All: I am trying to create a hyperlink from the values in a html table. This is what I have so far: CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c='`column header name4`,'&PFC='`column header name5`,','`column header name6`,'&PCN='`column…
-
Calculating index vs Year Ago
i have a calendar date column and a sales$ column. i would like to calculate sales index vs year ago. How can i do that within Beast Mode? Date: Calendar date Sales $ e.g: Sales IYA = (Sales $ on 15May2020) / (Sales $ on 15 May 2019) * 100 is there a way i can shift the date to create a (sales $YA) column?
-
Beast Mode - Revenue from a negative to a positive
Hi, Novice beast mode user here and currently our data flow is showing revenue as a negative number and expenses as positive numbers, however I would like revenue to also show as positive. I tried the below beast mode calculation below, but it didn't work. Any advice on what beast mode calc, or other way, to turn revenue…
-
Is it possible with Magic ETL to append a dataflow
Is it possible with Magic ETL to append a dataflow with a dataflow that has the same source just more updated data?
-
Beast Mode Cumulative Sum Calculation for given scenario
Hi Team, Request you'll to provide insights and case statement to get to the attached desired results. - Cumulative Amount Current Year-2020 - Cumulative Amount PreviousYear-2019 - Cumulative Amount for last 5 Years-(2015-2010) - Cumulative Amount Lifetime Thanks in advance.
-
Calculated Field for Word Frequency in Word Cloud
I have a card which uses the word cloud visualization to show the different search terms my Domo users are searching forover the last 30 days. It sounds great in theory however it is displaying too many words, making the word cloud hard to read. As such, I want to create a calculated field for the word cloud that omits all…
-
Randomizing a field value
Is there a function or trick to randomizing a value when running a dataflow? For example, I have 4 rows with a column value of ABC. When running the dataflow, it should randomize that value to NVA across the four rows.
-
Cards for "Today" go blank at UTC time, not local time
I need the Dojo collective mind! I have a card that shows KPI for only "Today". At 5 PM Pacific time the card goes blank (as if it thinks the day is over). I am physically in the Pacific time zone and all of our date/time data going into Domo is in Pacific time. I have since learned that Domo assumes all data coming in is…
-
Sales per Business Day Total
I have a dataset that is structured in the following Columns: Date, Segment, # Units Sold, and Goal Units Sold. Rows are by day and segment. (6 segments, 6 rows for each day) It is joined with a calendar dataset containing a column for the count of business days. My goal is a table metric, like the attached, that shows #…
-
Beast Mode help-Case When
I am having an issue in my dataset with a CaseWhen statement. I need write a statement that says, if this amount has the same invoice number, check number, "hceck number" then only pull one of the amounts. Currently my data pulls both amounts and then my data is duplicated.
-
Where to find Beast Mode documentation
Where can I find documentation on functions in Beast Mode such as median()? Median is not listed in the reference guide . Also, where can I find documentation for the SQL functions we can use in Beast Mode such as PERCENTILE_CONT?
-
Version Control for Dataflows via GitHub
Hey Community, I am trying to find out if any of you have tried to Version Control your Dataflow transforms via GitHub? I can pull and access the data through the Domo CLI, but I would like to use GitHub centrally at my organization and make changes to Domo through this service. If this is possible please let me know.…
-
character in saved beastmode some how replaced with exclamation point - !
Good morning Has anyone ever experienced a character in a beastmode syntax being replaced by an exclamation point? I created a beastmode probably about a year ago and validated it against the data, and at the time, it worked properly. We've since updated to a different dataset and copied all the beastmodes from the old…
-
Last 7 days COUNT for each day
Goal: I want a total COUNT of rows for the last 7 days, for each day. Meaning, that I have Ex. a line graph where the point for 5/22 includes the previous 7 days (5/15 - 5/21) and the point for 5/21 would be the total of 5/14-5/20 and so on. Context: I append data every 15 minutes to a dataset that shows the current users…
-
BeastMode Help: Days Remaining in Quarter
I've got a beastmode I am trying to create that will calculate the days remaining in a quarter. * If the quarter is already over I want to show a value of 0 (not a negative number). * If the quarter hasn't started I want to show 91 (that's the number of days in a quarter) Any help would be appreciated. Also if this is…
-
Passing Value At Run Time
Hi All, Is there any way that can be used to pass the value to DoMo Dataflow at runtime? Thanks & Regards usr12321
-
Case Statement Issue: Summing (minutes / 60 = hours) / Count (Distinct)
Aloha, I have been reading thru the boards and still have no solution. Of course, I am still a novice at this....Here goes: If column Specify type of PFC activity: = Video Teleconference Client Contact then sum column "Enter the number of minutes......" / 60; which would give me hours. Then, divide the total hours by the…
-
"Invalid query, DataSet schema needs to be updated" Error message
Hello, Ive recieved this error message when running my dataflow "Invalid query, DataSet schema needs to be updated". What does this exactly mean? The run was successful and shows about 2.1k rows, but won't let me see them in the Data tab. Thanks!
-
cannot switch dataset created from view
I created a dataset using View, however, when I try to switch the dataset to use this view-dataset in the existing cards, it just say: unable to switch card. I am able to create a card from scratch using the view-dataset. Does anyone have similar experience? I wanted to update a page with more than 50 cards with this…
-
Running Total Window Function not working
I've got the following BeastMode to calculate the running total over time based on the date. I've utilize window functions before but this one doesn't seem to work. It keeps failing with an error "An issue has occurred during processing. We are unable to complete the request at this time." (It'd be nice if we had better…
-
Create a tier label based on the aggregate value of the client instead of the account level
Hi. Wondering if somebody can help me with the creation of Tier Labels based on the aggregate values at client level and not the individual account. My data is organized as follows Reporting month Account Product Type ClientNo. Balance This is what I was doing but I got stuck with the creation of the labels and the…