-
Want to add minutes of a particular day from different rows
I want the sum of downtime in minutes for a particular day. Eg: 14th May had a total downtime of 33 minutes. I want to have a single row for 14th May with downtime 33 minutes. How can this be done?
-
Quarterly Chart
I am trying to create a line chart and graph it by Quarters but the only thing is that instead of summing the values or taking their average, i want to only take values for the last month of the quarter. e.g For 2022 q1 it would be march 2022 , q2, june etc
-
Prevent Beast Mode Sharing on Dataset
Is there a way to prevent users from sharing Beast Modes on datasets but still allow them to create cards?
-
String Aggregation in Beast Mode
Hello everyone, I am trying to come up with a table that shows the unique emails of subscribers, and to which partners they're subscribed to. I'm trying to concatenate the partner field so that those with multiple subscriptions will remain unique. Is there a way to do this in a beast mode? I saw in some training video that…
-
Hi Team, Need help in converting a string value to date.
Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a date and so i do not get options to filter month and year. I want a way by which i can convert these to a date value. And…
-
Remedying Data Recording Issues on the Front End in Domo
I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not all people) record their transactions all at once, combining what should be multiple revenue values into a single one.…
-
Aggregate Count While Still Filtering By Time
I want to make a pie chart out of the following rows where a row value is based off the count (not just 1). The rows are grouped by time. The table looks like the one below. The problem is the chart doesn't aggregate Success to 12 but leaves them as separate series Success 5 and Success 7 in the legend. I have multiple…
-
Fixed Function - More complicated function
Hello, I keep getting an error when I am trying to do this equation: SUM((SUM(Website Engagements) / SUM(Page Views)) fixed (filter none)) It works when I just have: SUM(SUM(`Website Engagements`) fixed (filter none)) But I do need to divide the total sum of website engagements by the total sum of page views with the…
-
Beast Mode: Count IF for user_id based on another column
Relevant columns in dataset user_id: unique identifier badge_level: a number from 1 - 4 user_badge_id: another unique identifier. Each badge earned generates a unique id I am trying to create a new column that counts the # of Level 3 badges the user has earned. Then I will create a Beast Mode to calculate the following %…
-
Color Rules for variable comparisons
I would like to be able to apply color rules on a value in comparison to another value, but such that both values can change based on filters. We have a group of schools for which we have student outcome date in aggregate by school, year, and assessment window. We currently have a School Value card and a Network Average…
-
Beast Mode Calculation Help Needed
I need to create a new Column via Beast mode called % Sales Material based on the following calculation. (Sales Price - Actual Cost) / Sales Price I am struggling with the exact Beast Mode Code because Sales Price is on one Line Based on WTSTEP 000 And Actual Cost is on a Separate Line and is based on Beast Mode Where when…
-
Setting up an alert
Hi Team, I want to set up an alert for my data whenever a new month comes in. Can you please advise how can i set that up considering i have a date field.
-
Is there a way to "lock" the beast mode with in another beast mode?
When I create a beast mode formula for say "X" then I want to create another beast mode which uses "X" and some other calc. How do I "lock" the original beast mode X so that I can update X later? Currently when you create/ use Y the beast mode for X shows up as the whole formula and isn't an exact field/ reference name. So…
-
issue with date format
I am using the below format for the date transformation. but not giving the proper format. the day value is incorrect. CONCAT(CASE WHEN split_part(`auditdate`- `submitdate`,' ',1) * 1 = split_part(`auditdate`- `submitdate`,' ',1) THEN CONCAT(ABS(split_part(`auditdate`- `submitdate`,' ',1)), ' days ') ELSE '' END,…
-
Need to calculate the difference between two dates with proper date format
Need to calculate the difference between two dates in Days Hours Mins seconds format. Wrote the below case for date difference but not getting the required output. Getting output as shown above in yellow: Need output as : 4days 21 Hrs 20Min 27sec
-
Nested Case When?
Hello. I have this slicer and its beast mode below: Here's what I want to achieve: If Project Maya is selected, the column 'Action' should show only 'Disregard' results. If any of the other 3 was selected, the column 'Action' show only 'Resolved' results. Not sure if nested case when statement will work on this. Please…
-
YoY Chart
I want to create a YoY line chart with Time on the x axis, YoY change on the Y axis and Year in the series. So it would have 3 lines for the years E.G 2021,2022,2023 How can i do this?
-
I want to calculate difference between yesterday and day before yesterday.
I want to calculate the difference between yesterday and day before yesterday to see no. of files received in that day. my dates are in the below format in one column, i tried the datefiff function but couldn't get the desired results please help
-
How to show YTD data in Tabular format?
I want to display YTD data in a tabular format. How can I achieve this using BM. I have a dataset with columns like 'Date' and 'Metric' The attached screenshot is a general idea of how I'm trying to organize the data. Thank you!
-
IN function
Is the SQL IN function not supported by Domo? I've noticed when I attempt to use this, the Beastmode (or ETL function) is saved without error, but it doesn't seem to pull in the results. i.e. case when 'event_name' in ('page_view','session_start','scroll') then 'Yes' else 'No' end
-
If date falls within the current month
I am trying to calculate the # of visits (that a therapist does) per working day against a goal of how many visits per day we budgeted them to do in a month. I am running into an issue with the calculation for the current month. For example, the goal for June was 22 visits a day and we had 733 visits in the month of June…
-
Slicer Question
I need to show the following slicer options: Amazon Mendel Amazon US Amazon International Amazon Project Maya I created a beast mode, only the 1st three options are showing. Amazon Project Maya does not show up in the slicer options. Does it have something to do with the one's highlighted below? The thing is, the Cust ID…
-
Filter Select: 2-day or 3-day data
Hello, is there a way in DOMO beastmode that we can filter cards and show past 2-day or past 3-day data? For example, the current date is 7/21/23: If I select past 2-day data: this will only show data from 7/19 and 7/20. If I select past 3-day data: this will show data from 7/18, 7/19 and 7/20.
-
How to edit DATEDIFF to calculate beyond calendar year
Hi, I have an argument where I am attempting to calculate how many consecutive days have occurred since the last specific event (See pic below). But when the 'Year' filter is applied to the dashboard and also filtered by a 'Region' and the event occurred in the prior year, I get a "no data in filtered range". Is there a…
-
How can i use alias with concat function in beast mode?
-
Combining Multiple Flags Using Concat() and case stmt
In my dataset, I have a multitude of different holds, and if more than one hold applies to the given order number, I want to have them all listed in this 'Hold Name' column i've created using a beast mode. However, when I start adding multiple case statements, the hold name column turns blank. How would I approach getting…
-
Need to create a ticket card which shows all raised, closed and backlog tickets
Inflow : Total tickets raised in the week Outflow: Total tickets closed in the week Backlog: Incremental open ticket count required as per week Beast mode created : inflow: count(CASE WHEN `status` <> 'Cancelled' THEN `incidentid` END) Outflow: count(CASE WHEN `status` = 'Closed' THEN `incidentid` END) Backlog: COUNT(CASE…
-
How to create a rate by specific selection criteria in Domo
Hello again community. So I work within a healthcare organization and I have a domo grouped/stacked bar graph built currently from an etl that has columns regarding patients readmission start date, account number, discharge date and attending providers(previous admission). The card breaks down the readmit percentage rate…
-
Aggregate a Beast Mode
Hello, I am working with a retail dataset and need to calculate beginning and ending inventories based on a user selected date range. The calculation is straight forward but the problem is aggregating the result so it displays on one row per item. The goal is a table card of items reporting beginning inventory, ending…
-
Calculated Column Errors - count conditions when like this but not like that
I would like to create a column in my dataset with a count of distinct session_id's where column event_name is 'search' but does not have an event_name called 'select_item' present as well. Hoping a beast mode will work because this is a gigantic dataset that takes hours to run. let me know if you think adding directly to…