-
Visual showing percentage of progress against target
Hi - I'm new to Domo, any help would be greatly appreciated. I have two totals, a 'target' total and a 'progress to date' total. Is it possible to show my 'progress to date' as a percentage of the 'target'? It doesn't need to be a bar chart, any visual will do. I've tried everything and I just can show the progress as 70%…
-
Is there any row_number or rank function in beast mode?
-
Beast Mode Syntax Error
I am trying to do a beast mode calculation and I keep getting errors COUNT(`Target_Review_Count__c`) / COUNT(DISTINCT `Session ID`) Calculation Error : Whoops! Something went wrong & it keeps changing to DomoHttpError
-
How do I change my week to Mon - Sun and fix this report?
I have an auto weekly report that shows the dates of a week and the corresponding data. The report goes out on Monday and I need it to show the previous two weeks (Mon - Sun), not including the current Monday data. Right now I have manually typed the dates (if 1.2.23, 1.3.23..then week = 1/2 - 1/8) and select the next week…
-
Is there a way to aggregate the output using a FIXED function used in a CASE statement?
I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate off of a "Week Number in Epoch" column, rather than comparing against Fiscal Week as we move into a Week 53. I previously asked about writing a temp table in a Beast Mode (https://dojo.domo.com/main/discussion/comment/59532),…
-
Using admin to add owners to multiple cards at once
Any video I see of these process seems to be from a year ago plus and I am unable to get to the same admin cards page. When I go to Admin - Cards I get the first image attached, instead of the page that comes up in the video/ second image, and on mine/the new page I am unable to change the ownership of multiple cards as…
-
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…
-
Month over Month Comparison on mega table/pivot table
i have some queries hoping if anyone could help. In particularly on Month-over-Month comparison. So i wanted to create a mega table/pivot table that will show companies Company |January | Febuary | March | April | Previous Month - Previous Previous Month A |1 |6 |8 |3|(-5) B |7 |5 |5 |9|(+4) C |6 |4 |5 |6|(+1) D |8 |9 |7…
-
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.…
-
ETL formula vs Beastmode - result discrepancy
Good afternoon, I've come across a headscratcher where a formula created within ETL is giving a different result when that exact same formula is created as a beastmode. In the attached image, the columns "island break" and "test1" are the exact same formula, with the former being created in ETL and the latter as a…
-
How should can i remove Dot "." from a column?
Hello, I have a column with multiple data and i need to remove the dot from all of it while keeping the letters and numbers. What should i use in ETL? Will Regex works? If yes, what should be the formula Example of column data: 12412.oaf.124R 124.1256612.124 saarw.124.1fs
-
Incorrect calculation when computing the value using case statement
Hi, The below beast mode in DOMO gives correct results when only 'metric A' is used as a filter in domo. When 'metric A' and 'metric B' is selected as a filter, the computed result goes a bit off. I have attached screenshots of the result. Note: The numbers changes for 5th Dec'22. Correct value is 72224.29 when used only…
-
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.
-
Can we include live commentary/Notes into DOMO Table card existing on dashboard?
-
Update Beastmode for % Right First Time (to remove exceptions)
Hi, Trying to work out % right first time (RFT) and am almost there. BUT, when using the calculation below, it counts all "discrepancies" as RFT (100%) where it is only those associated with the 'not in' discrepancy records which are 100% and those which don't fall into the numbers listed as 0%. Please could you help with…
-
Remove column from a dataset
Is there a way to remove a column from a Domo dataset? I have a dataset which I am unable to use in an ETL because it contains a floating decimal column which occasionally has the number expressed exponentially which the ETL is unable to parse. And I can't alter or remove the column in the ETL. I'd prefer not to have to…
-
Query to create a condition on a database
Hi everyone, I would like to know how is the syntax to create a condition column (if) on a database, for example: The column "PPG" already exists and i want to create the column "Gr" with this information. If PPG = "MPA 90GRS" then Gr should appear "90". Could someone help me with this calculated column, please?
-
Fixed Functions along with Case statements
in the below data i require the sum of Value 2 when the sum of value 1 for the distinct values in the key column is greater than 0 the expected answer for the below will be 1+2+5+6 = 14 i can derive the SUM of value 1 by using the fixed function SUM(SUM(`Value1`) FIXED(By `Key`)) However, when i wrap it inside a Case…
-
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?
-
Assigning blank value as Zero
Hi All, I have a field by the name rate which has decimal values and this field is coming in from a google sheet.. I have a lot of rows of this field as blank ...Can you please let me know how to replace the blank values as 0.. I am currently using this case when ifnull(rate,0) then 0 else rate....This is giving an error
-
Getting incorrect result while computing an output using Beast mode
Hi, The below beast mode works perfectly when only 'metric A' is selected as a filter. However, when 'metric A' and 'metric B' is selected as filter under 'metrics' then the resulting value changes. Note: I have attached a screenshot when the correct value is coming with only metric A as 72224, whch changes to 72213 with 2…
-
Add beast modes already created to a dataset
Is there a way to add beast modes already created into a dataset? When I want to create a new card using the same dataset I've used before, I'm not able to find a way to add a beast mode that's already created from a previous card. I have to go to that previous card, copy the beast mode and create a new beast mode to the…
-
MAGIC ETL Formula
Hi Guys, I am working on a workflow, I have two datasets I combined using left join. Now I have a new column "Category". Now those that are null in the category column and have have "AB" text on its Product Group name should be identified as "Above Normal" and those that doesn't have should be "Normal". But when I run it,…
-
Domo Ideas Exchange - Beast Modes - First / Last Days of the Month / Week
Problem: How Do I calculate the start or end date of the week or month? Solution: Last Day of the Month: This is fairly simple as we can use utilize the LAST_DAY function which will return the last day of the month for the provided date. LAST_DAY(`dt`) First Day of the Month: For this we can do some simple math to subtract…
-
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?
-
Working with Multiple Date Fields
I'm struggling to find a solution for creating things like conversion rates between metrics that are dependent on different date fields. For Example: looking for the ratio of leads created (created_date) and how many demos were scheduled (scheduled date) in the same month. It's important to note that the scheduled count is…
-
Combining 2 datasets together
Hello, I'm comparing quotes against sales data. They are both powered by separate dataset. Each quote has a unique ID that is later being copied into sales dataset names as quote #, if that quote turned into sale. I appended both datasets together and now I'm trying to write a formula that would show me which quotes turned…
-
Percentage Calculation
Hi - I am trying to find the % of one column of items compared to another. Specifically, the percentage of "online appointments" (a filtered option of "all appointments") compared to "all orders submitted". I cannot figure out the formula. Previously, when figuring out the % of online scheduled appointments compared to all…
-
Can you subtract days based on case when statements?
Hello! I have a case when statement that I need to subtract a certain amount of days based off of: Case when 'ID' = '1066' THEN `Maturity Date` - 45 when 'ID' = '1019' THEN `Maturity Date` - 55 when 'ID' = '2600' THEN `Maturity Date` - 66 when 'ID' = '2507' THEN `Maturity Date` - 70 when 'ID' = '1075' THEN `Maturity Date`…