-
How to set up a min/max equation in a Beast Mode?
I would like to setup a beast mode to calculate a fill % for contracted values, however I would not like it to show any values that went above 100%. I know in Excel it would be as easy as =MIN(100,SUM()) How would I accomplish the same thing within Domo? The two columns being run against each other are as seen below. Total…
-
Making a Field to Calculate 'Yes' or 'No' Sales for last quarter
I am attempting to build a beastmode that gives me a value of ‘Yes’ if there is a “sale” in last quarter or a "no' if there isn't. Here is my code so far: *‘End of Business Date’ acts as a current date function in our dataset. The issue with this is that it does count all the rows from last quarter as a ‘Yes’, but if there…
-
12 month rolling pivot table with filtering capabilities
Hi all, I have a customer that is looking for a way to create a pivot table where value for each month is a sum of current month + previous 11 months (so in total we have 12 rolling months). For example, value for Dec'22 = sum of values from Jan'22 to Dec'22. Below is the formula that they created for this but when there…
-
How to combine federated dataSet to another dataset?
I tried to combine 2 datasets using ETL but then realized that Federated dataset does not support ETL. So is there any other method to combine 2 datasets on this case? Thank you,
-
Combine date columns
Is the below logic possible? If appeal determination date is blank, insert determination date, if not insert application determination date?
-
Formatting a table
I have a table which I would like to have sub-rows providing sub-total numbers for each month. It currently looks like this. How do I get it to look like this? Where the total rows are emboldened, the color coding applies to their respective columns, the “Count x/y” is replaced with Total in the Retailer field, and the…
-
beast mode calculation
I am trying to create a card that shows the percentage of data. I have a field from salesforce that is Target_Count__c and I need to show the how many targets actually have a date in the X12_Month_Review__c section (# of follow up reviews / percentage of target count). I tried to use this formula and filters but nothing is…
-
Count Distinct with Fixed?
Do the fixed functions actually work with Count Distinct? I'm trying to leverage them to ignore some filters, but they're not producing the right results (always significantly higher). The example below does not include the filter bit since I can't even get the base of the function to work correctly. The window function I…
-
Success Rate %
To work out the success rate I need to (a) count number of rows where 'Status' column has 'Application Granted' and divide this by (b) count number of rows where there is a value in 'Determination Date' column. A / B = Success rate Any help would be much appreciated, cheers
-
Is there a way to create a filter for line charts
Is there a way to have a multi-line chart connected to a filter which can allow a user to select which metrics they want to see on the chart?
-
Adjusting Axis values vs values on line chart
For line charts (or any type), is there a way to differentiate the value format on the axis and the values displayed on the lines? For example, below, I'd like the left axis to display percentages with no decimal (5%, 10%, etc. -- NOT 5.00%, 10.00%), but for the values displayed on the line nodes to have two decimals…
-
Is it possible to count a value depending on other values?
Hello, I have a big table with different kind of data and I want to create a calculated filed that counts how many "active" status do I have depending on the month, client and country. For example, I want to know how many activate status do I have in January for Client A, which is in Country A. This is an example of my…
-
Divide numbers from same column based on criteria from another column
I have the following dataset, and would like to create a DAU/MAU ratio for each day. I would want to create a beast mode that powers this number and can be used to generate a line chart at daily level.
-
Creacion de Metricas
Buenos días, hay alguna manera de aplicar filtro al nivel formula y hacer una métrica calculada, por ejemplo: Crear una métrica de sum que se aplique a una categoría en particular. En powerbi, se usa la calculate y se agrupa SUM+ FILTER. Que variante hay en DOMO?
-
How do I get value and Percent of total.
There were 86 terms and 269 terms. How do I get value and percent of total? Do I just work it into a beast mode?
-
Using date filter as input for Beastmode calculated field
Hi, I have a Beast mode calculated field where I use MAX('Sales_Date') to keep the calculations fresh automatically (as we are getting the data with 1-2 months lag so I can't use current date). Problem is when users start changing the date range filter in the dashboard to a range not including the MAX('Sales_Date') in the…
-
Calculating only the distinct values for many duplicate sessions
Hello! I'm working on a conversation dataset that has a lot of duplicate values as our API creates a duplicate session ID for each part of the conversation someone reaches when they engage with our experience. My problem is I'm having difficulty calculating that average conversation duration because each duplicate row per…
-
Filtering data automatically for a specific Monday in a Domo dataset
Hi Everyone. I have a Domo dataset that updates daily but I need to create a chart that is essentially a snapshot in time showing WoW as of every Monday. I am not coming up with any way to do something easily in BeastMode that would work for me. Any help is greatly appreciated. Thanks!
-
Can we save / export the projection data as a dataset in Domo Analyzer Cards?
We have created a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved. Any idea how to create this dataset or export it from the card?
-
updated workbench version, now workbench service keeps stopping/failing
Hi, We updated to workbench 5.2. I just clicked download and install. Now our workbench service continuously stops. Has anyone ever had this problem?
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Percentages on this table
It comes out all zeros. Here is what I have so far. I tried count. Any ideas? case when `Ethnicity` = 'White' then 'White'/`Count` when `Ethnicity` = 'Asian' then 'Asian'/`Count` when `Ethnicity` = 'American Indian/Alaskan Native' then 'American Indian/Alaskan Native'/`Count` when `Ethnicity` = 'Black or African American'…
-
String to date
Hi, I'm trying to take the 'DUE DATE' column below (covered by the mouse) and turn those numbers into dates. 20123 is supposed to be 02/01/23 The solution I first thought of was to just split the columns but because it is showing up as text, it wont do that. Is there a beast mode to just pull the last two, the middle two…
-
HELP with Case When Statement
I need help on how to code this in beast mode. (It's like I need to tag a specific column that it's either included/excluded based on the CASE WHEN statement). I just dont know how to do in using the proper syntax. CASE WHEN ........... Then <field name> 'excluded' Else <field name> 'included' END
-
Correlation analysis in Domo?
Is it possible to conduct a correlation analysis in Domo using ETL (or other means)? If so, how? P.S. my analysis will include 3+ variables
-
Disregard this.
-
How to work a dynamic textbox
I want a simple card that says "Data through [Date]" where date is the latest/max date value in my dataset. How can I do this...? I've tried using a Dynamic textbox, but I can't figure how to get this (seemingly easy function) to work.
-
Displaying Average of Data with Average of Each Part of the Series
Hello! I have two call types. Let's call them Inbound 1 and Inbound 2. I have a graph that doesn't distinguish between the two but averages both of their Handle Times into one line. I have another graph which displays their average Handle Times split into two lines, Inbound 1 and Inbound 2. I am looking for a way to see…
-
Regex Replace Issue
Hello, I'm trying to do a regex replace to grab a combination of letters and digits but throw out the rows where I don't get anything. Here is my formula: case when REGEXP_LIKE(`Asset name`,'^.*([a-z]{4,5}\d{6}).*$')=1 THEN REGEXP_REPLACE(`Asset name`,'^.*stc=?([a-z]{4,5}\d{6}).*$','$1') else NULL end To explain, I'm…
-
Cant get the percentage of the total!!!
Hi All I'm trying to calculate the percentage of a column (that is aggregated) using this beastmode (SUM(CASE WHEN `Cluster` = 'Greater North' THEN `Uno` Else 0 END)) /Sum(`Uno`) *100 However, in the table it shows "100" although in the Total it does have the right percentage!! (sse pic) What I am doing wrong? Thanks