-
Combine date columns
Is the below logic possible? If appeal determination date is blank, insert determination date, if not insert application determination date?
-
Count Distinct with Fixed?
Do the fixed functions actually work with Count Distinct? I'm trying to leverage them to ignore some filters, but they're not producing the right results (always significantly higher). The example below does not include the filter bit since I can't even get the base of the function to work correctly. The window function I…
-
Success Rate %
To work out the success rate I need to (a) count number of rows where 'Status' column has 'Application Granted' and divide this by (b) count number of rows where there is a value in 'Determination Date' column. A / B = Success rate Any help would be much appreciated, cheers
-
How to get Last Week/Last Year/etc through dataflows
A lot of premise here so bear with me. I have a dataset containing financial data for a 14 day period (Sold Units, Retail, Expenses, etc). Every 14 days I upload the latest data from the raw source online. I load that data into Domo workbench and have it append the new data so that everything is in the same place. So each…
-
Divide numbers from same column based on criteria from another column
I have the following dataset, and would like to create a DAU/MAU ratio for each day. I would want to create a beast mode that powers this number and can be used to generate a line chart at daily level.
-
Calculating only the distinct values for many duplicate sessions
Hello! I'm working on a conversation dataset that has a lot of duplicate values as our API creates a duplicate session ID for each part of the conversation someone reaches when they engage with our experience. My problem is I'm having difficulty calculating that average conversation duration because each duplicate row per…
-
Filtering data automatically for a specific Monday in a Domo dataset
Hi Everyone. I have a Domo dataset that updates daily but I need to create a chart that is essentially a snapshot in time showing WoW as of every Monday. I am not coming up with any way to do something easily in BeastMode that would work for me. Any help is greatly appreciated. Thanks!
-
Multiple Event Types on a Calendar Card
Hi all, I've been working on a release and defect calendar card and have encountered some limitations with the current calendar card - I've managed to map all defects onto the card with no problems; however, I want also to include a separate event type in the same calendar for a version release date. Effectively the story…
-
How to use a beastmode to divide X from the same time period between 2 years.
Hello, I have an 'hours' worked column broken out by work date in my dataset. I'd like to be able to sum the hours worked so far this year, and divide them by the sum of hours in the same time period last year. For example, summing the hours from Jan 1st, 2023 - Current Day and dividing it by the sum of the hours from Jan…
-
Multiple Case statements
Hi there, I am trying to make a table that has the following columns. Customer Name / AW 2022 Pre-Orders / AW 2022 Replen Orders / AW 2023 Pre-Orders So what i need is a beast mode formula that can get me data based off the 'Invoiced Month' of 10, 11, 12. The 'Invoiced Year' of 2022 and 2023. And finally the 'Sales Order…
-
Toggle series in bar chart
Hi, I have a bar chart that has a goal as the y axis and then a current total as the series (as well as the difference between goal and total. We also have another field in the data that has a different calculation of the total. I was wondering if it is possible to have a card on the dashboard that allows us to toggle…
-
Sum Orders, Line Count, Sales by day of the week (Friday, Saturday, and Sunday)
Hello, my dataset has 7 columns: Invoice date, location, orders, ... invoice total (see screenshot); I want to sum orders, line count, and sales by day; meaning January 21 2023 Friday's orders =DC 12 ATL's orders + DC 11 MOB's order = 65+0. Friday's sales = DC 12's Invoiced total + DC 11's invoiced total = $10,932.39 + 0.…
-
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.
-
Dynamic Rank Beast Mode
Does this functionality exist yet? When I try to do a rank() in a beast mode it skips from 1 to 16 every time no matter how I adjust my order by or partition, the only way rank() seems to work correctly is in the ETL itself, however I want to be able to filter the dataset and have the data rank accordingly by the filters.…
-
Beast Mode: How to calculate Fixed Average dependent on a different Fixed Sum
Hello! I have a dataset with the following fields: Day, Company, Spend, and Revenue. I want to find the Average Revenue per Company for a selected time period, but only include Companies that have cumulative Spend greater than zero (for the selected time period). I have attached a photo of my sample data. Basically, I want…
-
Calculations using analyser or beast mode
Hi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc). In the attached, columns 'CAP' and 'ITB Not Built' use different filters to get the final number. All I need to do is add CAP and ITB Not Built together for each client. Pipeline is just these two figures put together.…
-
Translate this error
Hi, I am trying to write a weighted average formula into an ETL. I am not sure what this error means. Can someone help me with what the syntax should look like so that I aggregate it properly? Thanks in advance.
-
Beastmode for multiple row comparisons to one source row?
I'd like to add a third column in a table visualization that displays the % change for the current week to each previous period listed. What's the best way to create a beast mode for this?
-
Comparing monthly income in a certain year to the same month income in previous year
Hello! I have a dataset which contains departments, dates (several years, daily) and income per that department & date. I'm trying to build a table that has departments in the rows and monthly income as values. The columns are a certain year and the previous year. Tried with Sum and Lag. How do I do that?
-
How to compare Value Columns
Hi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?