-
Unable to use "AND" filtering
I have a column named "response_value" which is to be used as a global filter in the dashboard. I would like to filter distinct users who have all of the selected values under column "response_value". Currently, it works like an OR condition and counts users who were part of any of the response_value selected
-
Pivot Table and Horizontal Calculations
Hello, Wondering if we can get some advice on how to program horizontal calculations in a pivot table. Please see below the current view of the Pivot Table and how we need to put in horizontal calcs.
-
Remove dates from a card with a beastmode?
Hi, is this possible?
-
Sorting Heatmap by Month-Year Concat on y-axis and Day of Month on x-axis
Hello, I have a heatmap that on the x-axis has the Day of the Month and on the y-axis has the month and year concatenated, i.e. January 2022. My question is how can I order the axes in such a fashion that I get the most recent month and year concatenation at the top of the y-axis and have the rest of the month and year…
-
Extract Quarter Value from Date Field and Return First Date of that Quarter
Hello, I need to extract the quarter from a date so it returns that quarter it falls into (example: 01/01/2023 falls into Q1. Instead of Q1 I want it to return the first day of that quarter. Example: DATE 01/05/2023 QTR DATE 01/01/2023 To note I am making a beast mode to do this in a view. I have already tried to use DATE…
-
Organize values on X-Axis
Hi All, I am trying to sort my x-axis values on roles (see screenshot attached) not on the default sort options available in Analyzer. I read a previous note from 2017 that told me to use CASE to sort, so I did: CASE split_detail WHEN 'CEO'THEN 1 WHEN 'Head of Business' THEN 2 WHEN 'key management personnel(KMP)' THEN 3…
-
Beast Mode Decimal number to Time Format
Is there a way to convert the current decimal number to (HH:MM:SS) format? We are using a beast mode that currently calculates minutes for us.. SUM(Talk time to decimal) / SUM(LIVE CONNECT count) = 1,167.83 / 85 = 13.74 mins.. Can i turn that into 00:13:74?
-
Can you use a beast mode in Segments?
Hello! I am trying to build out a Segment although for some reason it isn't populating when I use a beast mode as the Columns to filter. Can you only use data from the flow and not use beast modes?
-
DateDiff formula in Redshift
Hi Team, The formula below was built as a beastmode but would like to move it to dimensions, the backend. However, "DATEDIFF()" isn't recognized in Redshift, any workarounds? Thanks CASE when ("date","published_date") >0 and DATEDIFF("date","published_date") <=29 then '01 Month' when DATEDIFF("date","published_date") >29…
-
Window function beastmode error-ing
I had a beastmode that worked (attached below), but now it doesn't work. The beastmode is intended to calculate a 12 week average for a KPI we track in the business. On the card where I'm using the beastmode, the card does not load and I get this error: "An issue has occurred during processing. We are unable to complete…
-
Beast Mode is valid but does not print all options, how can I fix it?
Created the beastmode below and although its valid I'm only seeing options "Low Performers" and "Other". The beastmode is suppose to look at revenue and at month-12 revenue and meet certain qualifications to identify it as either Non Public Videos, Low Performers or Videos Exceeding Lifespan. Thank you in advance! i.e. if…
-
How to make FILTER ALLOW clause dynamic?
Hello all, I want to make it so that a user can decide on what columns that a particular chart could be filtered on. For example: SUM(SUM(Website Engagements)) FIXED (FILTER ALLOW (case when Allow Filtering - Website = 'Mobile Device Type' then Mobile Device Type else Mobile Device Type end)) This is a fixed function with…
-
Creating a Beastmode that meets Revenue Requirements
Hi! We're looking to build a beastmode that meets two requirements to then print a result. For example if a video generated more than $1K in total revenue and more than $100 during month-12, then "repost". See current beastmode below: Background: The dataset tracks the lifespan of revenue per video title, in a 12-month…
-
How to reference a Beastmode in another Beastmode?
For example we have beastmode-A that tracks monthly revenue for 12 months, and I want to reference this beastmode-A in beastmode-B which will say "Month 12 > 100 then XYZ". Any ideas are greatly appreciated! Thank you!
-
Fixed Function Problem
Hello, I have an issue that I'm working through in which I want to essentially group by two columns and find the average rank in that grouping. I then want to filter this rank to be less than 3 and count the total rows from this. All in a beastmode. The SQL behind this looks like the following: SELECT Count(*) from (SELECT…
-
Filter by Section of Dataset (Bonus point question!)
Hi Everyone, this is a bit tricky. There is a need to have an aggregate table that shows counts, sums, and averages for different sections of the same data set. But subsets of these sections are defined by matching filters on the dashboard. I know that doesn't make much sense, so here is an example of a simple table.…
-
Case when SYNTAX
Hi all, I am trying to write a case statement for a column when we see a null to grab another column. I am not sure why I am not getting the output expected. Can someone take a look and maybe advise? Essentially 36534370 and 36534369 from the investor_loan_id column should be in the left column as well. **I've tried to…
-
Unable to save card with Beastmode active
I have a beast mode that validates and appears to work as intended. However, when I try to save it as an active filter, I get the "There was a problem saving your card…Contact Domo Support." If I move the remove the beast mode from the filter list I can save the card. The beast mode is: CASE WHEN (RANK() OVER (PARTITION BY…
-
Average Length of Stay in Beastmode
I am trying to get the average length of stay using our admission date till our discharge date. I tried using the datediff function and got an error when validating, "Calculation error: whoops! something went wrong." I have flipped the discharge date and the admission date and the same error comes up. I feel like I am…
-
Looking on a specific date
Hi all, I am working in Magic ETL. I have group two different datasets on their 'lock_dates' I have created a calculated column where the number of locks are counted in each data set. Then I created a column that told me if dataset 1 matched dataset 2. All of this is shown below The issue I am running into is seeing that…
-
Date Picker & Period Over Period Chart Enhancements
We have end users who want to set a date range and see the change compared to the corresponding previous period. Currently, in PoP cards, you can: Set a comparison period on the cards that overrides the dashboard date picker OR Use variables and Beast Modes to create current and previous period calculations and add the…
-
Beastmode Case Statement with NOT IN operator
-
locks = locks?
Hi all, (I recently posted something similar but updated my dataflow to a new output so wanted to share and clarify) I've got two columns, rate_locks_powerlender and rate_locks_powerseller, that I need make sure are equal to each other. The power lender is slower to update so we do not have data later than 9/11 so I am…
-
True/False Beast Mode Syntax
Hi All, I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set. I can visually tell that they are the same but I am trying to write a beast mode to…
-
How to reference a Beast Mode in antother Beast Mode
I've seen this in Ideas Exchange, and it sounds like it's coming, but it's not here yet? What's my alternative for now? In my database, I have an attribute that contains values from 1 to 10. I need to invert these in Domo, and I have a simple beast mode which does that (1=10, 2=9, 3=8, etc.). I now need to reference that…
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Formatting Summary Number For A Calculation
Hello All, I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation (Cost/Leads) and while I've been able to figure out the font size and color, I am still struggling to control the format to be a currency without decimals instead of the number its at now Right now, I've…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Last 13 Months Using Selected Date Slicers
Is there a way to pull the last 13 months for a visualization using a selected date in the dashboard? For example, if I filter for 12/2022 it gives me 12/2021 through 12/2022 in bars?