ColemenWilson Coach

Should be: CASE WHEN `Type` IS NULL THEN 'Daily' WHEN `Type Sourced Daily` IS NULL THEN 'Monthly' ELSE 'Mutual' END You need to drop the extra "ELSE" and use single quotes ' ' instead of double quotes " "

You have to use the Group ID and you can find it in either the Domo Governance Dataset "Groups" which can be found in the appstore by searching "Domo Governance Datasets Connector" or by going to the group in Domo and copying the ID from the URL:

No problem! You'll need a configuration dataset as an input. You can use a webform or make it dynamic with an ETL output. You will need these fields spelled exactly as seen below (case sensitive)

Yep! You can do this using the Group Management tool in Governance Toolkit. It is free. If you don't see it reach out to your CSM. Go to More > Admin > Toolkit > Group Management > New Job > Manage Landing Pages If you get stuck creating the job let me know!

I'd recommend doing a union and doing your best to map similar fields together. It is likely that there will be fields that just don't make sense to union together, but I'd think for many of them it would.

You could do this a couple of ways. You could talk to your CSM about inline editor. You could embed some kind of form: Smartsheet form, Microsoft form, Google form, etc… on the dashboard next to the card using a DDX brick and iframe. There are also DDX bricks that allow for inputs. For each of these options, aside from…

Domo can’t recognize a filter to show null records. The easiest thing to do is create a new field with a beastmode that is something like this: CASE WHEN Brand IS NOT NULL THEN Brand ELSE ‘null’ END Null values will then be replaced with the word Null and you can apply the filter as you would normally. you could also use…

Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo. https://domo-support.domo.com/s/article/360043436753?language=en_US Otherwise, this sounds like a job for Workbench…

Hi @shreeyab, If you are looking for a counter for days, it would be a beastmode or formula like this: DATEDIFF(CURRENT_DATE(),`yourDateField`) If you'd like more detail, it would be something like this: CASE WHEN ((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600) < 24 THEN…

@random_user_098765 you're welcome!

No. All you have to do is set the color rule criteria in the color rules. For the above image I just set anything above 75 to be orange. You can set as many color rules as you would like. Maybe I am misunderstanding what problem you are having.

Something like this? The same can be done when a series (multiple lines) have been applied.

I lost an hour of work today due to an accidental deletion of a string of tiles in an ETL. Please add an undo button to magic ETL!

It is a new setting added in the admin settings. Just go More > Admin > Company Overview > Enable Advanced Color Options. Once that is selected you'll be able to use Hex Color Codes again.

You'll need to join the single value to every row in the dataset. To do this, create a constant value, you could call it 'Join column 1' and it could be the number 1 or any other value, and include it in your group by. Then split out a new flow from WC WCB Activities and create a constant value column called something like…

I generally use the formula tile over text replace in most applications. You have many more options for text replace because you have the full suite of MySQL text modification available to you. https://dev.mysql.com/doc/refman/8.0/en/string-functions.html

In addition, and perhaps this is what you meant by manual work, you can create copies of a dataflow with one click. I often do this if I can going to rip apart a dataflow as a backup.

I would recommend using the formula tile and using a case statement. Something like this: CASE WHEN `city` IN('hon, HI','HI','Hawaii','Whatever else') THEN 'Honolulu, HI' ELSE `city` END

@fadhlirrahman The next step would be to save and run the dataset and then create a card in which you can use a table card to show the longest average time between orders and the average number of days by using the DATE_DIFF() function. Let me know if you get stuck!

So does this not work for you: CASE WHEN `LOCID` IN('A','B','C') AND `flags` = 'Y' THEN 'HUB' WHEN `LOCID` = 'HWV' AND IFNULL(`PROD_CD`,'999') IN ('RSALE') THEN 'HUB' ELSE 'Not HUB' END What issue are you running into? The IFNULL isn't really necessary since you are only looking for values = 'RSALE' in your case statement.

And if you'd like you could upvote my idea to improve the email connector here: https://community-forums.domo.com/main/discussion/60745/customize-email-address-in-dataset-via-email-connector

I agree that it does not seem to change anything when enabled. My guess is that it may have to do with Brand Kit, which our instance does not have enabled. Brand Kit is a Domo paid feature that allows for instance wide branding - including colors. Perhaps when enabled users could override the default brand colors for…

Easiest thing to do is have 2 beastmodes: Current month and YTD. When the card is set to current month, only rows that match that criteria will be shown. An alternative would be to use Magic ETL to calculate the YTD value and populate it for every row in the dataset. Then, use that field in the card and just set the field…

Hello. You need to set a color rule for when Oct 23 = 'Complete' as shown similarly below:

Not that I am aware of. I would recommend submitting that as an idea in the https://community-forums.domo.com/main/categories/ideas Happy I could help!

No and the documentation is terrible: https://help.woosender.com/en/articles/6716814-integration You could look at using the JSON No Code Oauth Connector: https://domo-support.domo.com/s/article/360052105454?language=en_US#:~:text=The%20JSON%20No%20Code%20With,account%20in%20the%20Data%20Center. I don't use Woosender so I…

Gotcha, for that we use the Domostats report called "Credit Usage" and filter 'Usage Unit' to "Rows". You may not have this domostats report enabled currently, but can request it be enabled by reaching out to your CSM. This report will give you the row count over time.

Using Variables! First, create this variable: Second, create this beastmode: CASE WHEN Date Variable >= MAX(Status Start) and Date Variable < = MIN(Status End) THEN 'In' ELSE 'Out' END Third, apply the beastmode from step 2 as a filter on the card and select In = 'In' Or Not In = 'Out' Fourth, apply different dates in the…

The best way to do this is using Domogov datasets. In the connectors in Domo search "Domo" and you'll see this connector. Look for the "Datasets" report and there is a field called "Row Count". Using this field you can build cards and alerts that will help you monitor the change in rows.