GrantSmith Coach

Yes, if they're interacting with the app you'd likely need a license. You may also be able to utilize Domo Embed / Domo Everywhere to embed the visualizations within a website which would go based on impressions and not need a Domo license. I'd talk with your CSM about your use case and what the best solution might be.

I'd recommend logging a ticket with support as it sounds like it's a bug. I'd recommend renaming your columns without the period if possible to avoid this scenario as a workaround.

Alternatively if your field may not have a comma but still has spaces surrounding two uppercase letters you can use a regular expression to find and replace your string: REGEXP_REPLACE(`addressfield`, '^.* ([A-Z]{2}) .*$', '$1')

Hi @NathanDorsch Regular expressions are your friend here for parsing this out of your URL string. You'd need different columns but you can do this all in the same Formula tile using different regular expressions: utm_source: REGEXP_REPLACE(`url`, '^.*utm_source=([^&]+).*$', '$1') utm_content: REGEXP_REPLACE(`url`,…

You can use a CASE Statement and DAYOFWEEK to check if it's before Wednesday and then configure and setup your date filters CASE WHEN DAYOFWEEK(CURRENT_DATE()) <=4 THEN offset logic here END

What is the error you’re seeing and what are you expecting to see? It’s hard to diagnose your beast mode without any context.

If you double up the single quotes it'll escape it to a single quote in your string: (CASE when `commitment_comb` like '%Q1 ''22%' then 'Q1 2022' else 'other' end)

Did you get window functions turned on in your instance?

You could utilize a Magic ETL dataflow and utilize the Rank and Window function to calculate the row number based on your partition and then use a formula tile to conditionally set the value of each record. CASE WHEN `Row Number` = 1 THEN 'Unique' ELSE 'Duplicate' END Row Number being the new field you calculated with the…

It depends on how you want to do the comparison. Typically when you look at period over period Domo will just subtract a 1 month interval which would make the 29th, 30th and 31st compare to Feb 28th. There are other options where you'd look at 28 days to keep the days of the week aligned (comparing the same day of the week…

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