-
Want to track progression and targets based per Quarter
Hi all, I've one datafile with sales with different products. Quantity is a column where I used 'sum' Target is made through a beastmode 'case when QUARTER(date) like 1 then 1250 else 0 end' Progress v2 is also made through beastmode and doesn't deliver the right results 'QUARTER(date) like 1 then (1250- (quantity)) else 0…
-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Step Ratios - Pivot Table
I have a pivot table showing total number of applicants through the recruitment process. I want to be able to show the "step ratio". Pivot Table has Steps in the rows, column is job type, values are a distinct count of candidate ID. Dataset has multiple rows per candidate, each step of the process they've reached. Im…
-
Case Statement - 28 Days from a specific date?
Hi All, I need to write a case statement that would calculate 28 days from a selected date. How would I write that? The end result would be total sales within the 28 days going back in time from the date selected. Thanks, Paul
-
Syntax Error in Beast mode calculation
CASE WHEN Sort: Month Number = 1 THEN NULL ELSE ( (SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) / LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number) ) END I'm not able to figure out what is the syntax error over here. Can anyone please help?
-
Show the Average in Bar Graph (Days/Hours/Minutes)
Hello. Can you help us find a solution how to display the output we want to achieve? This is the current output that we have, but we wanted to see a view using bar graph. The problem is that, the values are 'string' and not 'numbers' because of the concat function we used in beastmode to identify whether the computed…
-
How to connect two cards.
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
-
Date Beast mode
Hi everyone, I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input. Country Plan Name Start Date End Date Status Delivered data available Austria Plan 1 1st Jan 2024 1st March 2024 COMPLETED YES Malta Plan 2 1st Jan 2024 1st…
-
lookup function in beastmode?
Hi all, I have a table that has these columns: loan number other loan number first principle balance hi type description 2nd mortgage amount is the field we are trying to create The logic is such: when hi type description = '1st mortgage' and other loan number is > 1 then i want to look up the first principle balance of…
-
Count of ID when condition is met
Hi guys, I hope you are able to help me with the following situation. Example: Customer ID1 — Customer ID2 — Status — .. ABC — DEF — ACTIVE ABC — GHI — ACTIVE LMN — OPQ — ACTIVE LMN — RST — INACTIVE Basically I have two IDs per customer, I now want to get a COUNT of "active per customer" but ONLY when Status = ACTIVE. My…
-
Date and hour values to timestamp
Hi Domo, I have two columns: a date column (date datatype) and an hour column (0-23 integer type). What formula could I use to combine the two columns into a timestamp, assuming the minutes, and seconds are zero? Thanks,
-
Formula to get percent complete
Hi. I have data with Plants and Tasks and whether the tasks are complete are not. I need a formula so I can have a percent completed for each plant based on the number of Yes tasks they have compared to total tasks. Then I need to group by plant and bring that percent into a table. Could someone help with this? The…
-
Carrying date range in hyperlink
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had? CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
-
Please Help - Cant get pivot table working properly
I am having a problem with a formula. I am trying to display Yes for a facility if they have a task event status in Completed or CompleteLate status. If they have a task in any other task event status I want to Display No. In my pivot table in domo I am getting an error of multiple results encountered for same location. If…
-
Pivot Table
I have data with plants and tasks. Each plant has a few daily tasks assigned to them. If the status of a task is complete or completelate the task complete column needs to be yes. If it is any other status I need No displayed. I need to aggregate at Plant level so unless all of the tasks meet Yes criteria I want No…
-
Modify formula
I need to modify a formula. CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END I have plants with event status. Each plant can have 1-4 tasks to complete a day. I need formula so if not all tasks are' complete' or 'completedlate' status (yes) then No. If all tasks are…
-
Dynamic Date within Beast Mode
I have a Beast Mode that is grouping transactions based on their date: CASE WHEN OrderHeaderLocalDate >= '02/27/2024' THEN 'Since Changes CY' WHEN OrderHeaderLocalDate >= '08/01/2023' AND OrderHeaderLocalDate <= '02/26/2024' THEN 'Prior YTD CY' WHEN OrderHeaderLocalDate >= '02/27/2023' AND OrderHeaderLocalDate <=…
-
Calculated field for before and after date
I have a calculation based on date that is only half working. CASE WHEN (DATE(Date)<'03/01/2024') THEN SS Revenue ELSE (SS Impressions*eCPM/1000) end In the formula, it is pulling in the correct amount when it is BEFORE 3/1/2024, but for some reason, it is returning 0 for anything after that date. When I look at the SS…
-
Create a date field from separate month and year fields
I have a data set that for some reason has a field for month and a field for year but does not have any date column. Is there a way to string this together in a beastmode to create a date by using the first of every month? Like "01/"&Month&Year?
-
Show only 2024 costs
My usual disclaimer: I am not a programmer, and usually need an ELI5 for this :) I have a version of this code working that is intended to show the total PlannedCosts when summing the 5 FinancialCategoryName types I have listed. Basically the same thing without the YEAR(Month,2024) AND piece. That works. Now I'm trying to…
-
Formatting Variables
Hi, I am using a variable and some values are %, others are $. However, I the formatting doesnt seem to change when I try to switch them to a string by using concat and adding a % or $. They just come out as 1000 instead of $1000 or 57 instead of 57%. Here is my beastmode. What might be causing this? CASE WHEN…
-
Count Distinct with Or Case Statement in Beast Mode
Hi! Happy Monday! I'm trying to create a beast mode in which I'm counting the distinct sum of registration IDs regardless of the number of products that are attached to that registration ID except when the product name contains 'Guest.' So if a person registers for multiple sessions all of those are under the same…
-
Word cloud in DOMO
I see that we do not have inbuilt feature in DOMO to do the text analysis within DOMO. I have got several comments extracted from survey. I want to create the word cloud only with the words and not the entire comments which is what displayed when using the word cloud in DOMO. I want to split the comments into words and…
-
Find and append a value to a field
I'm trying to align some inconsistencies with our data. What I'd like to do is find any value that does not end with a '/' and append it with that character. Is there a case statement where we can look for a field that does or does not end in a character? I assume if I can do that, I can just append those without with the…
-
Period over Period Beast Mode
I am trying to create a beast mode that will show me the change from last year's sales to this year's sales. I need it for a table. If anyone has any solutions, that would be amazing.
-
How can I calculate Current Month's Visits/Working Day * Next Month's Working Days?
The picture is of my current card. I want to use April's Current Visits/BD (Work day) * May's Work Days to get May's Projected Visits, same for at least a 3 month projection. I have tried different forecasting options in the card and am not getting May's Data or correct projections for the other data. The Arrived and…
-
Calculating Time Diff (in hours) over Multiple Days
Hello 😊 I am trying to write a beast mode that will calculate the time difference in hours (sometimes over a multiple day period). For instance, if the start time is 4/1/24 at 1:00pm and the end time is 4/2/24 at 9:30am I would like the beast mode to calculate 20.5 hours. Any help is appreciated! Thanks!
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
-
Trying to create vertical bar chart that shows Count of Jobs based on Hours of each Job?
Hello, I am trying to create a distribution that shows the count of transactions ("jobs") grouped into buckets of hours. I thought using a window function to partition the hours buckets by Job (X-axis) and then doing a count(distinct) of jobs as the Y-axis would work, but it's not grouping correctly. When I set the Hours…
-
Using LAG() OVER function to get difference in a Snapshot dataset
Hello! I am trying to get the right formula to calculate the difference in data within a table (same data APPENDED to create snapshots). Here is an example of a beast mode I have been playing with. I have unique data by Opportunity ID & Snapshot YearWeek in the rows summarized in this chart, I would like to take the 202413…