-
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…
-
Hiding of filter funnel and pdp shield
is there a way to hide the filter funnel and the pdp shield? i have several cards where these icons block the bottom left cell in a data table. If there is not is there a way to justify the data in the data table to the left?
-
Null values in date fields
Hi all - running into a simple count issue here wanting to count all Invoice IDs where the date fields discarded_at and archived_at have no value. Summing invoice amounts with this syntax works - sum (case when discarded_at is NULL and archived_at is NULL then Invoice Amount (cents)/100 else 0 END) When I try to do the…
-
Beast mode errors in dataset views
Hi, I am struggling to create a simple beasemode in a datasetview, grouped by quarter. I am creating a new cost column, containing usd_cost for each account unless it is one of the 6 listed accounts and then use the marketing_cost. I am unable to validate the beast mode ("Whoops error!!" is not helping) The column names…
-
beastmode
I working on a categorical text dataset with thousand of rows, I have a text column called 'indicatortext' with 21 distinct values , I have another column called 'result' with 7 distinct values, I want to create a table with indicatortext as the row and the percentage occurrence of one of the categories in result column,…
-
Showing some values based on SUM, other values based on the most recent date available for the week?
I am working with a dataset that pulls in sales and inventory data for items on a daily basis. In data analyzer, I created a table with the data grouped by week. After grouping by week, most of the fields in my card (i.e. Revenue, Units Sold, etc.) are aggregated by SUM because I would like to know the sum of all of the…
-
Beast Mode to Compare Dates with IF
Hi again, This might be my last piece to finalizing my current dashboard. Each project has three types of go-live dates: Initial Adjusted Actual For each of these three types of go-live dates, there can be 10 instances, so 30 date attributes in all. They're numbered Initial 1, Adjusted 1, Actual 1, Initial 2, Adjusted 2,…
-
Does the Beast mode consume credits
Hi, I would like to know if the beast mode consumes credits by creating calculated fields
-
Filtering table by selecting from chart - or showing hover text
I have a dataset with data along the lines of: UserID - Order Date - Order Number - Customer Name - User Purchase # etc. I have a chart to show first time purchases by users (where user Purchase # = '1'). and then a table below to provide more information on the customer. Is there a way to filter the table by the users…
-
Dynamic beast mode for "how does my brand compare to the other brands" without showing brand names?
Goal: To allow 40 external brand partners to individually log in to their own dashboard and view not only their own sales metrics, but also how the other 39 brand partners sales trends compare to their own, without showing the individual brand names or $ amounts just % comparisons in trends for each month. Questions: Can…
-
Case Statement with Count Distinct
Hi I am trying to write a case statement to find how many individuals are admitted (so admitted = admission date present AND discharge date and decreased dates are blank). I have this so far: Count (DISTINCT Case when (STATUS = 'Admitted') AND DISCHARGEDDATE IS NULL AND DECEASEDDATE IS NULL THEN IDFFORMID END I want to…
-
Sum a column and divide by the count of unique entries in another column
I have a dataset around training. Each row represents a training course taken by an employee, so each employee will have many rows (1 for each training course taken). One of the columns is training hours. I would like to make a single-value card that shows average training hours per employee. In excel, I would sum the…
-
Adding extra budget condition in Beast Mode
Hi team! This is my first post here, and I'm very new to this. I've built some incredible dashboards in Domo, but when it comes to code, I struggle a lot. I have this simple Beast Mode working well (although it won't paste those funky apostrophes): case when Actual Costs > Planned Costs * 1.01 then 'Over Budget' when…
-
Sort by Top 20
Hi, I am currently looking at a healthcare practice's insurance list, which is hundreds long. I would like to create a chart with only the top 20 most commonly used insurances. Is there a way to do so in beastmode? I've tried chart properties → general → maximum rows (20) but it didn't work. Thanks!
-
Beast Mode Combining Columns
I need help figuring out if I am doing this beast mode correctly… We have an ETL that is not calcualting the sum correctly, so I am trying to use a beast mode instead.. I have 6 Columns I need the sum of divided by 6 more columns to equal the AVG I have tried several differnt ways to complete this - each column has value…
-
How to count strings in a column containing a comma delimited list of strings in each row
Hello, I have a field in which each row contains a comma delimited list of strings. I'm trying to find a way to display how often each string appears in the dataset. For example, the column might be "City": Row 1 | New York,Boston,San Francisco Row 2 | Boston Row 3 | New York,San Diego Row 4 | New York,Topeka I like to…
-
How do I get the Medium of a BeastMode result?
Hello, I created a Beastmode that is giving me the aggregate percentage of all the values in those fields. I need to get the medium, is there a way to do this. Calculation I am using
-
Heat Map Hours Off
Hi, I am trying to make a heatmap. I created a beastmode to help organize the hours to go in chronological order (attached screenshot). However, this doesn't seem to be working (attached screenshot). I am not organizing the times by count in the filters. Could anyone help me figure out what I'm doing wrong? Thanks!
-
Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…
-
Creating new field by summing two values from existing field
Noob here trying to not bother our internal devs… I'm working on the chart below which is charting 3 join method values by month (noted in key below). I'd like to consolidate the Live Stream and PhoneAutomatedPin into one new value called Unassisted Entry such that the bar chart only shows Unassisted Entry and…
-
Table card percentages
I'm working on a table card and I can't get the percent of total. I've tried a lot of things and I can't get the percent of total to come out. I have 193 total. Does anyone have any ideas?
-
Beast Mode Percentage
Pretty new to domo but is this formula the correct way of getting the percentage of items "sum(`complaint`) / COUNT(`job_number`)" complaint is either a 1 or 0 and job numbers are integers The ask is something like this English > German - 1467 jobs received in the past 12 months - 58 complaints received - 3.95% complaint…
-
Calculate Hours since Start Time
I am trying to calculate in hours the difference from Current Date and Time since Start Date and Time. I have a column that contains the Start Date with time and a blank Complete Date column since we only want to see actions that are pending to be completed. I have tried different variations of TIMEDIFF but I haven't found…
-
How to Aggregate DateTime Differences
Scenario Transactional product tables often have multiple date columns that need to be compared and aggregated. Many reports will require the average time between dates to track the overall progress, for example a customer transaction table might have the following date fields: · “purchase_date” · “ship_date” ·…
-
First Non-Null Value from Column in Formula Tile
Greetings DOMO, Does anyone know how to find the first non-null value of a column in a formula tile. Tried using Coalesce along with a few tricks and couldn't get anything to work. All help would be appreciated. Cheers, Will
-
Calculated Column using Current Date
Hi There, I am trying to use a similar calculated column I had in Tablau that I use to filter out some data from my dashboards. Basically, I want to look to see if there has been a 6-day lapse since today and a ‘credit release date’. I am getting a syntax error with the statement I am using below. Any ideas? case when…
-
Creating a Heat Map Based on Start and End Times
I have a data source that includes one row each for scheduled activities, with a column with the start date/time and end date/time (i.e. 2022-09-06T09:00:00 and 2022-09-06T13:00:00). What I need to produce is a heat map showing blocked out times in hour or half hour increments on a heat map, with the days of the week as…
-
Beast mode function to get 5% after getting the sum
I have a beast mode function that adds several rows, but I can't figure out the beast mode if I want to get 5% after getting the sum. For example 5+5=10 multiply by .05 to get 5% of 10. My current beast mode to add several rows is below- IFNULL(BuyerDebit,0)+IFNULL(SellerDebit,0)+IFNULL(BuyerCredit,0)+IFNULL(SellerCredit,0)
-
Count Unique IDs by Month-Year
Hi all, I have a date column (formatted as a timestamp ex. 2022-02-17T23:57:03Z) and a column of Unique IDs in my dataset. I am trying to create a new count column which provides the count of each Unique ID within a certain Month-Year in each row of my dataset. For instance, if I have 3 unique counts of Unique IDs in…