コメント
-
Try something like this to make it a bit simpler: REPLACE(REGEXP_REPLACE(SPLIT_PART(SPLIT_PART(``, 'Sent:', 1), 'To: ', 2), '[^<]+<([^>]+>)', '$1'), '>', ',') SPLIT_PART(``, 'Sent:', 1) Gets evertying in your string before 'Sent: ' - drops everything after it SPLIT_PART(SPLIT_PART(``, 'Sent:', 1), 'To: ', 2) Gets the…
-
Are you wanting the From and To both to be included or just the To? Will the From and To fields only have a single email or would there be multiple emails?
-
CASE WHEN Prod Art = 'A' THEN 'Artwork' WHEN Prod Source = 'M' THEN 'Sourcing' ELSE 'No' END
-
It sounds like you're wanting the value difference instead of the percent change. You can update this under Chart properties - Change value options - Value = Value Change
-
Try converting to a window function so that each row is compared to a single value instead of the aggregated value. CASE WHEN `D's % of AOR` = MAX(`D's % of AOR`) OVER () THEN 1 ELSE 0 END
-
Domo visualizes data on a row by row basis so if there's no data for a given month it won't show anything. You'd need to restructure your data so that every month has a value. You could utilize the Date dimension dataset, filter to the granularity you need and then left join your dataset to the date dimension dataset. Once…
-
There isn't an option currently to do this but I'd recommend adding an idea to the idea exchange for this feature.
-
Currently this isn't an option in the box + whisker plot but I'd recommend adding this to the idea exchange to show bot whisker values.
-
^ - Start of the text $ - End of the text Combining them together in the rexex above simple enforces that the entire string is made of numbers instead of just finding numbers anywhere in the string
-
If you're wanting to only find values which are all numbers you can use a regular expression: CASE WHEN REGEP_LIKE(`SERIAL`, '^[0-9]+$') THEN 1 ELSE 0 END If you're wanting to include numeric like characters as well (decimals and dashes) you can use \d instead of [0-9]
-
Nested bar charts only support showing the overall total. I'd recommend utilizing a Symbol + group bar or a Line + group bar chart and have the average be the symbol or line
-
Domo can't fill in the dates automatically within the card, your only option is to expand your data set to be on a per hour basis instead of per day.
-
This is something that Domo has to do as it's a special publish that they do. I'd try reaching out to support and see if this is something they can do for you or log this idea in the idea exchange.
-
Currently I don't believe this is an option but I'd recommend adding this to the Idea Exchange
-
You can leverage window functions to do this: SUM(SUM(CASE WHEN `Task Complete` = 'Yes' THEN 1 ELSE 0 END)) OVER (PARTITION BY `Plant`, `Date`) / SUM(SUM(1)) OVER (PARTITION BY `Plant`, `Date`) This will conditionall return 1 or 0 if the task is complete or not and then sum that value up for all tasks for each date and…
-
I'd recommend logging a ticket with Domo Support to have them investigate their connector as they have access to the actual source code of the connector.
-
MIN(MIN(CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END)) OVER (PARTITION BY `PlantID`,`Date`) You can use a window function to return the minimum value (No if any of them are No) for each date and plant ID.
-
Domo has their AI suite to utilize LLMs in a magic ETL.
-
you could create your own Date dimension dataset in an ETL and supply your own logic. Then you can ties that y to your datasets to get your custom calendar information
-
You can try and utilize a window function for your date instead of '04/08/2023': MAX(`OrderHeaderLocalDate`) OVER () - INTERVAL 1 YEAR This will look across your entire dataset and get the maximum date and return it for each row.
-
Here's a regex version: REGEXP_REPLACE(`field`, '^(.+)\/?', '$1/')
-
To Edit Domo (DDX) Bricks you need to have the edit cards grant. Participant users don't have this. If you want users to create or edit cards you'd need to potentially create a custom role that mirrors the participant user but also includes the grant to allow them to edit Domo Bricks.
-
When using date variables we have to define a specific value, it'd be great if it would allow the selection of today as a default as I'm typically wanting to use today's date with the variables. This would also allow me to not have to keep updating the default date as it gets farther away from the current date.
-
Domo has Writeback tiles you can use to write data from an ETL out to another location. Google Drive Writeback: Google Enterprise Drive Writeback: Google Sheets Writeback:
-
currently this isn’t an option but I’d recommend adding this to the idea exchange
-
@MichelleH - Have you tried turning it off and on again? 🤣
-
I'd recommend adding a new idea in the idea exchange to allow the NetSuite Analytics connector to use the new Connect Browser instead.
-
When doing Period over Period analysis I recommend restructuring your data to make visualizing your data easier. I've done a write up on this previously here:
-
Per Dates inserted into the table need to be formatted yyyy-MM-dd'T'HH:mm:ss.
-
I've found that refreshing the page typically will load the page's contents.