ColemenWilson Coach

Hey @ColeStuart, I helped you with the previous post you referenced. Here is my checklist whenever I get these errors: Did the file somehow get saved locally and is no longer in OneDrive? Is the file still shared with edit access with the service account/Integrator account in OneDrive? We have a dataset that runs that…

Are you using numeric values? It won't work with dates, text, or any other dimension - only numbers.

Hmm I am not getting the same error and I've applied the same settings as you. Can you share your beastmode? Also, if you switch the chart type to a table card and then do no aggregation and use CORR(field1,field2) do you get the value you are expecting?

Hmm I didn't realize you wanted to see the correlation coefficient change over time. For that you'd need to use fixed by. Something like this: CORR(Field1,Field2) FIXED (BY Date)

It works. Give it a try and let me know how it goes! Example: CORR(field1,field2) There are many functions that work in beastmode that are not displayed in the functions list in beastmode editor.

There is a CORR() function you can use in a beastmode. Example: CORR(field1,field2)

If you are doing this in Magic ETL you would use the Group By tile and group by `Country` and then choose SUM as the aggregate. If you are doing this in a table card, all you have to do is bring the 2 fields into the table card and then sum the `Value` field and it will auto group by unique instances of the other field. If…

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. 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.

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:

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…