-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages. For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together…
-
Is there a way to store a beast mode in a filter on a dashboard?
Is there a way to instead of having the beast mode in our cards for the guage multi value visual (Impressions, Web Page Visits, Visit Rate, etc.), have it in a filter that links to the cards in the campaign? Instead of having a static last 30 days vs previous 30 days, our client suggested that it would be great if there…
-
Case statement with multiple conditions
currently I have this query and I have 16 exclusion reasons. Is there a more efficient way to write this beastmode? CASE WHEN exclusion reason 1 IS NULL THEN CASE WHEN exclusion reason 2 IS NULL THEN CASE WHEN exclusion reason 3 IS NULL THEN CASE WHEN exclusion reason 4 IS NULL THEN CASE WHEN exclusion reason 5 IS NULL…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…
-
How can I change the order of columns in chart?
Hi guys, I have been trying to reorder my chart chronologically backwards. I have 3 columns that I want from left to right, Current Year, 3 years ago, 5 years ago. The table is transposed. Every column header on the left (transposed) is a beast mode. I have tried clicking the arrows next to 'Year of Tour' and it never gets…
-
Case statement
Case when Toggle = 'Key Brand' then ( case when Brand = 'BL' THEN 'BL' when Brand = 'SC' then 'SC' when Brand = 'RC' then 'RC' when Brand = 'RO' then 'RO' when Brand = 'PU' then 'PU' else 'OTHER BRANDS' end) END I am trying to use this case statement to make it react to toggle but i want to find a way around other brands.…
-
Word Count
Is there a way to create a field or value that identifies the number of words in a field? Preferably ETL, but Beastmode if necessary.
-
Sum of units sold, rolling 30 days
Looking to replicate the exact data layout above (side by side columns) in a table in Domo. So units sold by SKU by month (got this far) but also a column for rolling L30 Days sum. I created a new column in the dataset for count of days from current for each row DATEDIFF(CURDATE(),(Calendar Date)) but having a challenge…
-
Averaging time/returning only whole numbers of a fraction number
Is there a way in a beastmode to make the following example numbers on the left below remove the numbers after the decimal? 14.1925 — 14 15.999 —- 15 0.98 — 0 I am trying to get the average time of day that donors answer their phone when we call. So here below this donor answered his phone at these 3 times (hh:mm:ss):…
-
SQL formula not working?
I have a series of tests that run to determine a pass or fail. All the formulas work but this one is giving me problems - CASE WHEN Critical/Major= 'Common' AND
No>= 2 AND Critical/Major= 'Major' AND No>= 1 THEN 'Fail' Any one know why this would not be returning a Fail?
-
Query Based on a Value Between Two Date Columns
I've got a data set that includes job tickets with create_date and last_update columns. If the date range for a card is set to include a date in between the create_date and last_update, the ticket should be considered "open" at that point in time, and any tickets outside of the date range should be considered "closed" at…
-
Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table. I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first…
-
How would I pull the highest rate over the last 12 months in a beastmode?
In an effort to create a comparitive gauge chart looking at the current month's rate compared to the avg monthly rate over the last 12 months, the highest rate over the last 12 months and the lowest rate over the last 12 months. This is the beastmode I'm currently working with to attemp to get the max rate:…
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
ダイナミック日付範囲フィルターに何の単位を選択してるかをBeastmodeで判定したい
皆さん お疲れ様です。 Domoのダッシュボード上の右上のダイナミック日付範囲フィルターにて単位を四半期とかヶ月に選択してるかをBeastmodeで見て判定でコントロールしたいですが、方法はございますでしょうか。 よろしくお願いいたします。
-
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…