-
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…
-
Aggregate Multiple Text-based Columns to Card
Hello Domo Community! Long time reader, first time poster... hoping someone out there might have a solution for a relative newbie to domo and using beastmode. The Sitch I'm working with a file right now that will show pass/fail results across multiple columns. Each column represents a different category of failure, and the…
-
Summary Number with 2 metrics needing commas and rounding
Hi, I am trying to make a Summary Number for a card with a calculated field that will look like this: 1,121 Loans | $211,100,123 or even better, if possible: 1,121 Loans | $211.1M The first number could be anywhere from 5 to 500,000. The second currency number could be anywhere from $10,000 to $1 Billion dollars. My…
-
CSS Span doesn't look right- Table/Checkbox formats
I am having an issue where I put a CSS code with span and color and in checkbox and in the tables with sorting now it doesn't come out right - it shows the code not the actual language and highlight. Here's the code I use: when `Type` = 'Backup' THEN CONCAT('NORM', ' ' , ' <span…
-
Month over month comparison
I have a dataflow that returns the first day of the current month up to the current date and first day of the last month line up to the current date. The dates from the Dataflow are April 1, April 2, April 3, April 4, May 1, May 2, May 3, May 4. Then I created cards and use the period over period. Here's the screenshot: I…
-
Account Ledger Running Balance Beast Mode
Hi All, I am having trouble coming up with. beast mode to create a running balance for an accoutn ledger. I have all of my charges and reciepts but i cannot create a running balance to show the correct totals. Any help with this would be much appreciated. I have atached a picture showing the card i am working with. As you…
-
HTML link to external software
Hello, I'm attempting to create a link on a table that will open up external software based on an invoice number but when I click the link that is generated, nothing happens. The beastmod below works if I replace the "officelink" with "mailto" which opens up the mail app but it will not open officelink. Is there something…
-
Summary Number Issues with Partitioning
Hello, and thank you in advance for your help, I've been driving myself nuts with trying to do this correctly. I am trying to build out a drill downs on cards according to the hierarchy of my company. These drill downs would show how often a user clicked on a link (%) at the lowest level, their organization above that, and…
-
Beast Mode "Share Calculation on DataSet" vs. Calculating in Data Flow
Hi all, Are there performance advantages to using the Beast Mode "Share Calculation on DataSet" to create a metric for a DataSet compared to putting logic/formula in a DataFlow to have the metric added as a physical column on the DataSet? Curious to learn others thoughts/approachs as to balancing when logic should be part…
-
MAX of SUM in Beast Mode Windowing Functions
Hello! Our org just had our windowing functions for Beast Mode turned on, and we're hoping to utilize it to calculate our MAX messages per second. Below is the logic I've gotten so far, but it does not work unless the table has all of the fields in it. We want to display the value dynamically, so we need to stay within…
-
Counts over time for things that have a start date and end date
Hi, I work for a recruitment company where we have contractors working. Does anyone know how I count the number of contractors out working over time when I have to take into account both a start and an end date? Without this I am unable do do any trends for my senior management! Many thanks Zena
-
Data Fusion not running
I've got two datasets 6.3M and 14.7M records. It's simple order and customer information tied together by a LONG (Numeric data type) ID field. Between the two data sets there's a total of only 64 columns so they're not huge but for whatever reason I can't get the data fusion to work. Occasionally I'll get the preview to…
-
No data to set up alert?
I would like to set an alert for when actual nb hours reach 85% of ave budget nb hours. When trying to set up alert I get this message: Set up your alert ruleNo alertable metrics found on this card. Please add a Summary Number or change chart types and try again. I'm not really sure how to correct my chart to get this…
-
Change in MySQL calculations
Has anyone else noticed that your MySQL dataflows started to evaluate expressions differently? Yesterday, I was using this where clause to filter for yesterday's date and it was working WHERE `Date` = CURDATE()-1 Admittedly, this is a lazy way of doing it... but, well... coders are lazy
-
Is there a way in ETL/Reporting to show the cumulative total for every month
I'm trying to show a dashboard where in I need to show the cumulative sum of the user count for every month. Need to have the month listed for which there is no activity also. In the above image, I have data for 2019-07-01 and then there is data for 2020-01-01. I also want to have data to show in between these months and…