GrantSmith Coach

Hi @Vandana You can use some window functions to get the row number SUM(SUM(1)) and then compare that number to 1 since you're wanting the first instance to be unique and all others to be duplicate. You'll need to talk with your CSM to get the window functions in beast modes enabled if you don't already have it. CASE WHEN…

@Hiraayub LAST_DAY(DATE_ADD(`dt`, INTERVAL 1 MONTH))

Hi @leeloo_dallas I may be misunderstanding your request but You can use NOT LIKE in a case statement WHEN `blox_section` LIKE '%lifestyles%' THEN 'LIFESTYLE' AND `blox_section` NOT LIKE '%health%' THEN 'LIFESTYLE' A simpler way would be to put your WHEN clauses in the order you wish for them to evaluate. So if any string…

With LAG you need to know how many records back you'd need to pull in order to properly forward fill that data that's missing. Instead I'd recommend utilizing two rand and window tiles to do a forward fill. Import the Domo Dimensions - Calendar Dataset Within your ETL: Left join you data to this calendar dimensions dataset…

Import the Domo Dimensions - Calendar Dataset Within your ETL: Left join you data to this calendar dimensions dataset Take this output from the join and feed it into a rank and window function COUNT your RPC OVER / Partitioned by the product and ORDER BY Date - This will get us a group number - essentially tells us when…

What specifically are you concerned about having a character limit? To my knowledge the API doesn't restrict anything that it sends back in terms of character limit. Domo will limit data in cells to 1024 characters but that doesn't deal with the API.

Hi @IanMaddrell You can pull in the Beast Mode metadata using the Domo Governance Datasets Connector and select Beast Mode from the report list. It'll have all the beast modes and the formulas used for you to do a filter on.

There currently isn’t a way to do this but I’d recommend adding it as an idea to the idea exchange.

Domo is only going to plot the data you have so you'd need to include those dates. You can utilize the Calendar dataset from the Domo Dimensions connector and left join your dataset to that based on the date as it'll have all the dates for you already. Then you just use the new date field from the dimensions dataset…

Hi @NathanDorsch Do you have specific records with 0 for that day or are those days missing in your dataset? If you have the dates in the dates in the dataset with a 0 value it should appear as 0 and drop down to 0 in your graph.

You might be able to do this with some window functions in a magic etl. You could do a lag function to calculate what the prior row value was. Then use a formula tile to check if it's a Conversion event and then return a value of 1, otherwise 0. Then you can use a Rank and Window tile to do a running total on that new…

The version of MySQL (5.6) that Domo is on doesn't support window functions so you won't be able to do that in a MySQL dataflow. You can do unbounded preceeding and current row within a Magic ETL 2.0 dataflow using the Rank and Window tile to do what you're wanting to do.

Hi @DomoNewbie Do you have any NULL values in your Value field? Subtracting a null value would result in a NULL.

Hi @vgupta Currently this isn't an option. I'd recommend adding it to the Ideas Exchange as an idea for an enhancement.

@MarkSnodgrass - First! 😂

You can use a conditional sum like the following (assuming you're not grouping based on the description field) SUM(CASE WHEN `Description` IN ('0_0-10_Period', '0_11-30_Period') THEN `Value` END)

Since you're only looking at the number of days in the current year have you tried using DAYOFYEAR(CURRENT_DATE()) as your denominator (I'm assuming this is the case since you mentioned 70 days even though you have 2021 as the year)? I'd recommend breaking down each component of your beast mode into it's own beast mode and…

@Dr_Duru I'm assuming you're using a MySQL dataflow here. What are you data types for field 3 and 4? String comparison is typically slower than numerical comparison. Also have you added indexes on field3 and field 4? I'd also recommend trying to utilize Magic ETL 2.0 as that is typically much more performant than MySQL…

To add my two cents to Mark’s answer: MySQL will load your datasets sequentially so the more datasets you have the longer it will take. Magic will load them in parallel / at the same time so it’s a lot faster. I try to use magic unless I need to do some very complex join. Even then I’ll have the MySQL do at little as…

I’ve gotten some success updating to the latest version of workbench and also pressing enter when I enter a value for my replacement variable. This will show an empty row but have found that typically will save the variable

Did you try and run the beast mode and it said it couldn’t find it or are you looking for it in the list?

@ankt84 Domo currently doesn't provide the actual owner of the beast mode in the governance datasets, only the card owner. I'd recommend putting this as an idea in the Idea Exchange.

Hi @Hedger You can use some case statements to convert your values to 1 or 0 and then add them together: CASE WHEN `Column A` = 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Column B` = 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Column C` >= 1 THEN 1 ELSE 0 END + CASE WHEN `Column D` >= 1 THEN 1 ELSE 0 END

@Chet Do you have multiple client IDs and secrets? Have you confirmed you're using the correct one (This has happened to me multiple times)? Are you able to make that API request using another tool like Postman to narrow down if it's something with how Domo is sending the request with the Domo action or if it's how Domo is…

Hi @Salmas In your example for Token ID 108 you have two records - Are you wanting to keep these records separate or should they be merged into a single row? Assuming they're separate rows you can use COALESCE and NULLIF: COALESCE(NULLIF(`A`, 0), NULLIF(`B`, 0), NULLIF(`C`, 0)) NULLIF returns null if the column given is 0…

If you reload the page does it still show it as having other objects being affected?

Single Value card with a beast mode will get you what you're looking for for the current date: DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL '1' MONTH), '%M %Y')

I've done write ups of this in the past about how to structure your data differently to get YoY periods like you're requesting. You can read up on it here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

How is this dataset coming into your instance? Through a connector or through workbench?

You can utilize Domo Workbench or the database connectors to write queries against your instance and bring in that data as a dataset but there isn't an actual interface to explore your data by writing queries against it,.