-
How do I get unique values from a column?
Hi all. I need help in getting the unique values from a certain column. See example below Say I have this column below with multiple duplicate names in it, I only need to show one for each name. Please help. If it's possible through beastmode, it would be better, because I'm also utilizing slicer/filter for this card, so I…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Can you remove filtering capabilities for specific card level for Participants?
I don't want to remove ALL filtering ability for participant-level users, but there are certain instances where that would be ideal. Is that possible?
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…
-
Way to Use Window Function to Find the Duration a Temperature Variable was Above a Threshold
I want to find a way to use a window function to find the duration a temperature variable was above a threshold, the timestamp at which the the temperature was above a threshold, and the range of temperatures when they were above the threshold. The data is organized as an identifier column, the timestamp column, and the…
-
Delta Difference
Hi Everyone, Hope you can help me with this one. I am trying to get the delta difference from both 2 months. Just to show how many volume increased previous to current month. Any reccomendations? Thanks!
-
Case statement
Case when Toggle = 'Key Brand' then ( case when Brand = 'BL' THEN 'BL' when Brand = 'SC' then 'SC' when Brand = 'RC' then 'RC' when Brand = 'RO' then 'RO' when Brand = 'PU' then 'PU' else 'OTHER BRANDS' end) END I am trying to use this case statement to make it react to toggle but i want to find a way around other brands.…
-
Grouping after Split Function
So I'm running into a bit of a snag. Say I wanted to just do the Beast Mode element and pull just what's in the Title(Column) for example: All this info is in the Title separated by a | if I wanted to pull the System name from the title and then group it along with others that come in with the same format but create a…
-
Sum of units sold, rolling 30 days
Looking to replicate the exact data layout above (side by side columns) in a table in Domo. So units sold by SKU by month (got this far) but also a column for rolling L30 Days sum. I created a new column in the dataset for count of days from current for each row DATEDIFF(CURDATE(),(Calendar Date)) but having a challenge…
-
Difference in Business Hours
I'm looking to get the difference in 'business' hours between two date/time fields. The business hour range is 9:00 - 17:00 (or 9am - 5pm), within weekdays. Additionally, If a user enters a Start Date after 17:00, the start date should get pushed to 9:00 of the next business day. For example, the following should have an…
-
Averaging time/returning only whole numbers of a fraction number
Is there a way in a beastmode to make the following example numbers on the left below remove the numbers after the decimal? 14.1925 — 14 15.999 —- 15 0.98 — 0 I am trying to get the average time of day that donors answer their phone when we call. So here below this donor answered his phone at these 3 times (hh:mm:ss):…
-
Beast mode to find last working day
Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday. If there is a better way to do this other than a…
-
Creating a group.
So I wanted to generate custom groups based on the first word being pulled from a data field. Example: System | Application | Client | Problem Say I wanted to pull whatever system app would be and generate a group for it to display on cards via beast mode. Also, would the same concept be possible if I combined two work…
-
How to build filters with images or icons
A Domo user was recently having a hard time figuring out how to incorporate images and icons into her filters. Here are a couple of awesome videos that helped her solve her problem. Hopefully, this can help anyone who runs into a similar issue in the future!
-
Why is this not working
case when Sales/Volume = 'Sales' then case when YEAR(`Datestamp`) = YEAR(CURDATE()) -2 then CONCAT(ROUND(SUM(Sales_USD)/1000000, 0), 'M') END
-
Query Based on a Value Between Two Date Columns
I've got a data set that includes job tickets with create_date and last_update columns. If the date range for a card is set to include a date in between the create_date and last_update, the ticket should be considered "open" at that point in time, and any tickets outside of the date range should be considered "closed" at…
-
I am trying to use a case statement with a Time field for a table but when
I am trying to use a case statement with a Time field for a table but when i do it the values come out to be empty
-
Possible to update multiple filtered dashboards from aggregate dashboard?
Hi all, I currently have a dashboard of about 40+ cards and am wondering if it's possible to create copies of the dashboard that filter the data (and doesn't allow for an unfiltered view). Essentially, the dashboard aggregates data from several partners but I want to create create dashboards for each partner without them…
-
Finding averages based on selected ID (client)
The data I am working is at an asset level (example below) and I would like to find the average of all client ages accurately when looking at any segment of asset. Client Account Asset Age Client 1 Acc 1 Sec1 50 Client 1 Acc 1 Sec2 50 Client 1 Acc 2 Sec3 50 Client 1 Acc 2 Sec4 50 Client 1 Acc 2 Sec1 50 Client 1 Acc 2 Sec2…
-
how to aggregate nested average case statement
Business task: "what percent of this region's sites beat their target signups YTD"? So I want to take the average daily signup for each site within a region and see if it passes its target. If it does pass, it gets a 1, else 0. After this, I then want to aggregate it to the region level. So for example if 5 out of 6 sites…
-
Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table. I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first…
-
Dynamically generate last day of prior quarter based on today's date.
Hello, I need help generating the last day of the prior quarter based on today's date. This is used to determine which variables should be displayed based on if their date column is between ranges based on the last day of the prior quarter. I have been unsuccessful in my attempts so far. Any help is appreciated.
-
ZIP code leading zeros being removed
I'm adding a dataset with a column for zip codes. The leading zeros are being removed when the data is uploaded, is there a way to prevent this/change the formatting for that column?
-
sum case
how categorical variables can have a numerical total of another numerical variable? for example i need sum THE TOAL OF SALE FROM DIFERENT BRANDS / TOTAL OF SALES. the query needs to be smart enough to determinate the different brans AND IN A GRAPHIC THE BRANDS NEED TO BE IN X AXIS AND % IN Y AXIS
-
Creating an Artificial downtime for maintenance for only week and work hours
I am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other system does not put in the factors of weekends and holidays as well as after hours. How can I calculate a correct amount of time between the starttime to endtime while only subtracting within the window. For example if A…
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
ダイナミック日付範囲フィルターに何の単位を選択してるかをBeastmodeで判定したい
皆さん お疲れ様です。 Domoのダッシュボード上の右上のダイナミック日付範囲フィルターにて単位を四半期とかヶ月に選択してるかをBeastmodeで見て判定でコントロールしたいですが、方法はございますでしょうか。 よろしくお願いいたします。
-
Value from yesterday
Hi guys, Im trying to pull in the value from yesterday to fit into a broader formula. The value is followers (social media). Pulling it in from yesterday gives me the latest total followers figure. Here is my latest attempt: SUM(`Followers'), DATE()-1) And broader formula is to achieve daily client account engagement rate…
-
filter large datasets
Hello Domo ! I have a problem that I have a dataset which consists of "reports". I want to visualise the reports with cards in DOMO. The are say 10,000 or more reports. Is there a way to load one report at a time into DOMO and the browser? We have a database with all the reports in it but the only solution seems to be to…
-
Beast mode for dates
I have a dataset that looks like this: Date. Customers Jan 01. 20 Jan 02 22 Jan 03 26 Jan 04. 29 What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode…