-
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?
-
I need to create a dynamic report that shows me data between 2 and 5 days ago
I've tried a variety of methods but can't get seem to get it accurate. Any help would be appreicated.
-
Capture Duplicates in DOMO
Hi DOMO - Is there a way to do this excel formula in Beastmode? =COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2) basically, it shows the duplicates based out of 2 columns. what we have is the Name and the Title and the location we want to see how many names have the same title for example: Peter Manager San Francisco Peter…
-
I'm stuck. Sum of a Windowed/Partitioned Sum???
I keep running into a wall with this. I think there is an easy answer, I just can't find it for the life of me. My dataset contains one row per store, per day. I want to display -- by region -- the count of stores with an average order value (AOV) less than $20. In order to do that, I first need to calculate AOV by store…
-
Filtering Rows without Displaying Them / Same-Store Comparison
I have a dataset of sales data with one record per store, per day, across multiple years. I used @jaeW_at_Onyx's offset date table solution to get YOY and POP comparisons; but I'm not positive that's relevant to my [hopefully simple] question. I'm trying to create a filter for same-store comparisons. I am defining…
-
Removing Duplication and Ordering Objects within a Concatonated Field
Hello, Our company offers several different product lines and I am attempting to count how many times each combination is owned. There is a field that comes through to Domo from a SFDC connector with this information, but there is a ton of duplication within as a customer can own multiple of 1 product. Example: I'm…
-
How to create a column which SUMS based on the grouping of another column
Hello, I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice. i have attached a simple table as an illustration of what i am looking to achieve. I do not want to write a formula where i have to continually…
-
Convert all dates to last day of year
I am trying to convert all my dates to the last day of the year in a beast mode. I have a column in my dataset that is already showing the year for the data and have tried this STR_TO_DATE( CONCAT(`YEAR`,'-',12,'-',31),' %Y-%m-%d ') It doesn't seem to work. Any help would be appreciated
-
I have an unexpected outcome of a beast mode calculated column, can you help?
Hey, I've been working on a dashboard that has a radio selector to select which project the dashboard presents data from. In this process, if an option is not set on the radio selector, my dashboard populates with "Please filter on Project" on most of my cards except one which is not behaving as expected. For context, each…