GrantSmith Coach

Hi @daniel_cruz_2016 This currently isn't an option. I'd recommend adding it as a idea to the idea exchange.

Addendum Here's a corrected / updated Magic ETL implementation as the prior version had some incorrect offset values. {"contentType":"domo/dataflow-actions","data":[{"name":"Domo Dimensions -…

Hi @user012068 What format is your data in? Is it already aggregated on a monthly basis or is it daily? You'll want to make sure your data is aggregated on a monthly basis and you can then utilize the LAG window function to pull the values for the past 18 months for each month. LAG(SUM(`patient_count`), 0) OVER (PARTITION…

I'm not aware of one that's broken out per state in a single dataset however some states websites may have this information. You could also search through data.gov which has some state level datasets. https://catalog.data.gov/dataset

Hi @micheleb Are you sorting your results on your card based on the the aggregated / SUM of your values?

Make sure you're using the correct layout id. Also you may need to do a PUT request to the writelock endpoint (https://[INSTANCE].domo.com/api/content/v3/pages/layouts/[LAYOUT_ID]/writelock ) to establish a write lock before attempting to save your layout and then issue a DELETE request to the same writelock endpoint to…

You can use the page layout API to get the definition and to also save the updated definition. https://[INSTANCE].domo.com/api/content/v4/pages/layouts/[PAGEID] use a GET request to get the definition and a PUT request (with the JSON definition as the body of your request) to save the updated definition Note: This is not…

Hi @user048760 You can utilize a beast mode to conditionally add the values together with a CASE statement: SUM(CASE WHEN `Marketing Channel` IN ('Yelp', 'Facebook', 'Google Ads') THEN `Value` ELSE 0 END)

@faithscent Domo now offers a new product called "Sandbox" which does what you're looking for where you can promote pages to "production". You can talk with your CSM to get a demo of it. It is a premium feature so it'll be an extra charge. You can read more about it here:…

Hi @LCash Just curious if you multiply your numerator and denominator by 1.0 to force them both to be decimals on the off chance that they were being treated as integers and doing integer division instead of decimal / float division. (SUM(column1) * 1.0) / (COUNT(column2) * 1.0)

Hi @eriena it looks like you’re wanting to do a offset year over year. I’d recommend using a custom date dimension to calculate the values for the prior year or whatever offset you’re wanting. You can read more about how to do this here:…

You can skip the last step of using COALESCE and just leave the values of NULL in place. Then count won't include those and should give you 0 for those.

Hi @AnaKS This sounds like a bug with Workbench. I'd recommend logging an issue with Domo Support. In the interim you could utilize a dataset view to drop the column and rename another after you import it into Domo.

You’ll need to have a record for each rep for each day. To do this you can import the Calendar.csv from the Domo Dimensions connector. Then run a select columns on your dataset to pull just the rep name. Run that through a distinct tile. Then for both of those use two separate Add Contant tiles to add a column called Join…

Hi @FXM32 You're receiving List as a text in your dataset because the CRM API is returning a list of values but the connector can't handle those values. You'd need to get CRM to return one record per CC or To field or you could write a custom connector to handle the data coming from the API properly. You may reach out to…

@Joe_M If you could accept the answer so that others can more easily find it I'd appreciate it. You can click on "yes" at the bottom of the answer when it asks 'Does this answer your question?'

Hi @Meha Have you tried plotting the durations using the total number of seconds then having your beast mode with SEC_TO_TIME as a tooltip to the set your data label or hover text to that tooltip?

Hi @Joe_M The tool tip fields allow you to put additional information into your hover text or data labels without having to generate a new beast mode to display all of the information that you need. You can refer to them in the analyzer settings as %_TOOLTIP1/2/3 etc

What is your beast mode you're using to calculate the percentage? Are you able to use a Magic ETL to pivot your data, calculate the percentage and then display the resulting data using a regular table instead of a Pivot?

Hi @Crisocir It's the number of blue cylinders displayed on the warehouse infographic. Each one represents a dataflow grouped by the types of inputs so you may have one for ODBC / Dataset via Email or Gooogle Analytics / WebForm etc. It's just grouping them by the unique input types for the dataflows.

Glad this worked out for you @Rvannoy . Can you make sure to accept the answer so that others can more easily find this in the future?

Glad this worked for you @Emma. Can you make sure to accept the answer so it's easier for others to find in the future? Thanks.

Hi @Emma You can use the COALESCE function to default a null value to a specific value. It does this by selecting the first non-null value in the list of parameters given COALESCE(`Total Stock`,0)+COALESCE(`Total QTY to be delivered`,0)-COALESCE(`Total fcst QTY`,0)-COALESCE(`Total Reqmt QTY`,0) If you use simple arithmetic…

Hi @simontarry76 You need to pass in the authentication headers. You can either do this an API/Developer token (More - Admin - Authentication - Access tokens). You'd need to pass in the header value X-Domo-Developer-Token: {TOKEN_VALUE} Alternatively you can do this also with a client ID and secret from developer.domo.com

Thanks @MarkSnodgrass I left out the greater than and less than because it kept auto formatting it as a quote and forgot to put them back in.

Hi @Rvannoy You can't dynamically configure the date selector to go 4 weeks back and 4 weeks forward in the same report. You could configure the card to have a beast mode such that it will compare the date to now - 4 weeks and now + 4 weeks and then return to include it or not. CASE WHEN `date_field` = CURRENT_DATE() -…

HI @Rvannoy You'll need to have data for those weeks in your dataset in order for Domo to pick them up. What I recommend is using the Domo Dimensions connector - Calendar dataset and left join your dataset to that specific one on a daily basis - then you can use a COALESCE on your field to default it to 0 for that week.…

I heard @GrantSmith will be there.

I believe the only updated data flag will only kick off the dataset copy of the origin dataset has been run after the last time the copy has run. This way it won’t keep importing the same data multiple times.

Ah, your data has some other cases than the original one. It's not capturing some of them because it's not configured in the same format. Try something like this: REGEXP_REPLACE(`Name`, '^([^,]+), (\w+)(( \w+\.)?)|( \w+)$', '$2$5 $1') Breakdown: Group 1: Last Name ^([^,]+) This captures () one or more + characters which…