-
Beast mode for dates
I have a dataset that looks like this: Date. Customers Jan 01. 20 Jan 02 22 Jan 03 26 Jan 04. 29 What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode…
-
Comment and Save Versions for Beastmodes
It would be great if beastmodes had a comment and save version function just like when we update dataflows. When we update the dataflow (in Magic ETL), it really helps to have the comment section for version updates. If we have something similar for beastmodes, it would be helpful as we can understand why certain…
-
Beast mode errors in dataset views
Hi, I am struggling to create a simple beasemode in a datasetview, grouped by quarter. I am creating a new cost column, containing usd_cost for each account unless it is one of the 6 listed accounts and then use the marketing_cost. I am unable to validate the beast mode ("Whoops error!!" is not helping) The column names…
-
Charting 2 Different Measures Fields
Hoping someone can help me. I'm working with a dataset that breaks out the Number of Questions asked (by users) as two different measures fields (in screen below) as: NoOfAudioQuestionsAsked NoOfTextQuestionsAsked I don't have access to the lineage to change this dataset and must work with it. Is there any way to bar chart…
-
Showing some values based on SUM, other values based on the most recent date available for the week?
I am working with a dataset that pulls in sales and inventory data for items on a daily basis. In data analyzer, I created a table with the data grouped by week. After grouping by week, most of the fields in my card (i.e. Revenue, Units Sold, etc.) are aggregated by SUM because I would like to know the sum of all of the…
-
How to compare last 28 days with prior 28 days?
Hello, I'm trying to compare the number of sessions in the last 28 days with the number of sessions in the 28 days prior to that. How do I accomplish this with a period-over-period multi-value chart? This seems fairly straightforward in google data studio But it seems like I'd have to create BM in Domo based on some of the…
-
Dynamic beast mode for "how does my brand compare to the other brands" without showing brand names?
Goal: To allow 40 external brand partners to individually log in to their own dashboard and view not only their own sales metrics, but also how the other 39 brand partners sales trends compare to their own, without showing the individual brand names or $ amounts just % comparisons in trends for each month. Questions: Can…
-
Fixed Beast Mode for Percent of Category
We're trying to get a percent of the total for each series category on this chart by using a fixed function beast mode: We're displaying the number of unqualified leads on the y axis and using the fixed beast mode as a tooltip field used in the data label settings. On the 27th the % should be around 23% as the total leads…
-
SQL in ETL
Hi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we are doing in a table is taking out extra characters from a column to create a new trade_id Here is how we are doing it. when I go to add the formula tile and copy and paste this syntax, ETL is saying it doesnt recognize the…
-
Filtering Records Based on Aggregate Criteria
I've been trying to do the following but can't figure out the best way to do it. I have a table that looks basically like this: user_id|ticket_id|inquiry_type I want to filter out rows for a specific user_id when ALL of the rows for that user_id have a value of "false_inquiry" in the inquiry_type field. But if the user has…
-
Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…
-
Creating new field by summing two values from existing field
Noob here trying to not bother our internal devs… I'm working on the chart below which is charting 3 join method values by month (noted in key below). I'd like to consolidate the Live Stream and PhoneAutomatedPin into one new value called Unassisted Entry such that the bar chart only shows Unassisted Entry and…
-
Top Sales Week by Closer
The objective is to get the closer's best week of sales without creating an ETL as we want this to be dynamic with the date range selected on the card. We have a list of sales (each have a unique opportunity Id) with project sale dates and closer names. I had thought this formula may work but I'm having issues: RANK() over…
-
Cards - BeastModes Need to Know the Dates that are selected by the user (card/dashboard level)
I am always trying to find a way to detect what the user has either selected for a date on the card or the dashboard when building my BeastModes. Can Domo not find a way to pass this in as say a Macro or something. And I am saying Macros for both the card and dashboard level date selections
-
Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7. I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases. case when combination = 'desktop' then…
-
Percent Change Beast Mode Calculation
I cannot figure out how to do the beast mode calculation for this. I would like a percent change column for the most recent month to the current month? How would I do this? I've tried watching videos and this data seems to be set up differently then those videos.
-
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…
-
Combine date columns
Is the below logic possible? If appeal determination date is blank, insert determination date, if not insert application determination date?
-
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
-
How to get Last Week/Last Year/etc through dataflows
A lot of premise here so bear with me. I have a dataset containing financial data for a 14 day period (Sold Units, Retail, Expenses, etc). Every 14 days I upload the latest data from the raw source online. I load that data into Domo workbench and have it append the new data so that everything is in the same place. So each…
-
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.
-
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!
-
Multiple Event Types on a Calendar Card
Hi all, I've been working on a release and defect calendar card and have encountered some limitations with the current calendar card - I've managed to map all defects onto the card with no problems; however, I want also to include a separate event type in the same calendar for a version release date. Effectively the story…