-
aggregating average value of a month
date any_hva 1/4/2023 123 1/4/2023 233 1/4/2023 234 2/4/2023 115 2/4/2023 111 I have a table in a following format, same dates are present in multiple records since there are other categories(not shown) in whichany_hva is split. I want to display a monthly chart in which I want to display average value per day. Just…
-
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…
-
How to use Beast Mode to Filter Out Specific Words or Phrases
Hi, I'd like to create a re-useable calc that will filter out certain words or phrases that are found in a field. example: Closed Description field might have the words or phrases below which I do not want my cards to display those records. SPAM, N/A, Dup, Duplicate Thanks, Lisa
-
Help with Beast Mode Formula
I need help doing a complex sum in a beast mode, as when I do it I either get an error or a totally wrong number. The formula I was given reduces to A/(A+B-C), and sums across the entire data set for whatever date range the user chooses. Each of the letter values will be either a zero or one for a given record based on…
-
How to calculate against row values, instead of a summation, when using a beast mode within a pivot
I'm currently using a simple beast mode within a pivot the table. The beast mode calculates the percentage change in the values from two columns. The issue is that, for subtotal and total, the beast mode is summing up all the percentage change values above it, therefore returning inaccurate values. Is there a way to…
-
Beastmode: Previous 7 Day Avg Comparison
I am working in a Mega Table transposing beast modes to get daily kpis. I would like to get the comparison of these daily kpis to avg for the 7 days preceding them: (current value - 7 day avg) / 7 day avg I'd like this beast mode to appear in a column next to the daily value for each day. I'm just not sure how to get this…
-
Dataset Beast Modes and Sandbox
From a sandbox perspective, I know that it doesnt actually promote/copy datasets from one instance (dev) to another instance (prod). However, we have some Dremio federated datasets currently in dev with a bunch of dataset calculations on them and we're trying to avoid having to re-create all the beast modes everytime we're…
-
Granularity Issues in Domo
Hello, I have a dataset that I'm working with that has my data at a granularity that is quite large. I then want to be able to group that by each individual session that happens on our website and sum the total time spent for that session. I then want to take the average across all sessions. But I want to be able to do…
-
Calculate the average normalized score in Beast Mode
Hello, I have data in this format: I want to perform the following calculation in Beast Mode and create a chart out of it: 1. For each Product, calculate the maximum possible score within that Product. 2. Divide the score of each employee (Name) in each Product by the maximum possible score for that Product. This is giving…
-
how to exclude all last Wednesday of every quarter?
How can I create a beastmode that exclude these dates from showing up in a card» 3/29/23 6/28/23 9/27/23 12/27/23 but also make it dynamic so that I dont need to hardcode these dates but it will exclude all last Wednesday of every quarter? thanks!
-
Beast Mode Fix?
Ok so I have a filter deny on a beast mode and I need it to be different but I cannot figure out the dimensions. The problem - each of the months below needs to equal 100% and within each month, we need a percentage of that 100% that are in the 'credit score buckets' Currently, the 6 columns add up to 100% and I cannot…
-
Get value for first day of the month
I need to be able to create a beast mode that does the following: for any given month sum up columns A, B, and C, then get the value D for the first day of the month, and implement the following formula: (SUM(A) + SUM(B) - SUM(C) / D for the first day of the month I can do it in an ETL, but that involves aggregations and…
-
How do you change a date to a digit to get a sum?
I have a column that has the completion date. I'd like to change that to a number 1, so I can calculate how many have been completed. If completion date equals 6/12/2023, 6/13/2023, 6/14/2023, 6/15/2023, or 6/16/2023 then change each of those values to the number 1
-
Smart Text / Summary Number
Hi Friends, Requesting for your help on this, please. Example I have three columns, 'Student IDs' and 'Course Category' (Science, Math, History) and another column which is 'Location' which I have it in filter Now I wanted to write in a text box. (Dynamic) Location has more number of Course Category students. Example : NY…
-
Beast Mode calculation works but when trying to insert into a card, I get an error.
Good day, I have a beast mode calculation that I believe can calculate the sum of accidents over the previous 12 months for any given month. My data set goes back 3 years on a month by month basis. Here is the current beast mode that works when I validate it: SUM(SUM(fieldsAccident Count)) OVER ( PARTITION BY…
-
How to mix and match Data
Number City 1000 A 1100 B 1200 C 1300 D E 1400 1500 F 1300 Hi Folks, Need your help pls. 2 Questions - 1) In the table above, you could see that 1300 is mapped to city 'D' but in last row it is blank. How do I map it using beast mode or Magic ETL to fill by Lookup in the same column. Req: Lookup in 'Number' and fill Blanks…
-
Global date range filter in dashboard, have it compare to exactly a year ago in guage card type.
I have a dashboard that displays metrics from social media platforms, and I would like to apply global filters so the client can filter specific dates, but then also show what those values were exactly a year ago. Example: Say the client wants to see total impressions for April 12-17, 2023. I would like the card to filter…
-
Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it. Thanks in advance!
-
WOW comp calculation not correct
Hello, I am looking at this Domo Card and the WOW Comp calculation looks incorrect. Last Week Spend is $0 and Spend 2 weeks ago is also $0 but WOW is not 0%. Does anyone have any idea why this can be the case? For reference: LW Spend calculation: sum((CASE WHEN ((FY Order = 0) AND (Fiscal Week No = (Current Week - 1)))…
-
IF Statement Inside Beast Modes
Currently, you can use the IF statement inside of DataFlows (both MySQL and Magic ETL v2). However, this function is not available in Beast Modes. Most CASE statements I write are small and simple enough (they only have two outputs) that I could write them in an IF statement. IF statements are simpler to write and take up…
-
Append Output dataset help
Hello all, I have an Magic ETL (A) that with a output dataset - say OUTPUT_1. What I am looking for, is when every time I run the ETL, I need the output results to be appended. At the same time it should not create duplicate records. I created a new Magic ETL (B) with this OUTPUT_1 as input dataset and outputted to…
-
How do I Compare Column A vs Column B in the same Value?
I have one value that goes back several years and id like to compare TY vs PY. How do i write the calculation in beast mode to subtract A vs B and finally show the % ∆? Thank you.
-
Question on Domo SQL syntax
Hello all, I am trying to do Magic Transform using SQL option. I have embedded a SQL query but it is erring as it is not compatible with Domo syntax. Appreciate your help in this regard. DATE_PART('WEEK',CAST(TO_CHAR(TO_DATE(TO_CHAR(PRODUCT_KEY),'YYYYMMDD'),'YYYY-MM-DD') AS DATE)) AS "SaleWeek",…
-
Date Transform
I Have a year and a month column in my dataset which are in the format of integers. I want to create a beast mode calculation to concat them and have them as a date field. How can i do that?
-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
Beastmode subtotal not calculating correctly
Hello, I am trying to figure out what is wrong with my 3 beastmodes. One for this year's email sends, one for last year's email sends, and one for this year vs last year's difference. Currently, the chart looks like this and the beast mode doesn't seem to be calculating correctly in each row plus the subtotal. This Year…
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?