GrantSmith Coach

You'd need to reach out to Domo to do a custom solution for you to customize how the scheduled reports are being sent out.

What format are your times in? It it the number of seconds or is it an actual time format with seconds? You'll either be rounding up or rounding down. So if you have 1:04:30 AM what should that equate to? What about 1:04:55 AM?

This is likely the issue of underlying Domo permissions as users would need to have dataset edit privileges to make changes to the dataset.

Does your data have the category and a NULL vale or is the category value missing from your dataset?

You can use the CONVERT_TZ function to convert one timezone to another. You just pass in the field you're wanting to convert, the timezone the data is in and then the timezone you wish to convert to. CONVERT_TZ(`Timestamp`, 'UTC', 'US/Central')

You can use a beast mode and a case statement to conditionally Sun your values the following will give you the percentage of offline. Create another beast mode for ONLINE SUM( CASE WHEN `appt_source` = 'OFFLINE' THEN 1 END) /SUM(1)

You’ll want to look into using PDP as you can define which rows are available to specific users without having the other data exposed to them. https://domohelp.domo.com/hc/en-us/sections/360007334593-Personalized-Data-Permissions-PDP-

You can use a formula tile to calculate the first day of the week. I’ve done a write up on how to do this previously here https://dojo.domo.com/main/discussion/52687/domo-ideas-exchange-beast-modes-first-last-days-of-the-month-week#latest

You can utilize some date manipulation and some case statements: CONCAT(CASE WHEN DAYOFMONTH(`End Date`) < DAYOFMONTH(`Start Date`) THEN `End Date` - INTERVAL (DAYOFMONTH(`End Date`) -1) DAY ELSE `Start Date` END, ' - ', `End Date` Breaking this down: CONCAT - Joining the two dates together with a ' - ' between CASE WHEN…

Hi @AshleySizemore Have you looked into PDP? This will allow you to set specific conditions and rows the users are allowed to see. You can read up on PDP here: https://domohelp.domo.com/hc/en-us/articles/360042935354-Best-Practices-for-Sharing-Content-in-Domo

You'll want to reach out to Domo Support has they have more insight into errors happening in the back end and can hopefully shed some more light on the error for you.

Workbench currently supports partitioning. Magic ETL currently does not.

You'd likely need to utilize a window function and a case statement. Something like this might work for you MAX(MAX(CASE WHEN `Country1` = `Concat Field` THEN 1 ELSE 0 END)) OVER (PARTITION BY `Part1`, `Country1`) Then use this field in the filter to ignore values of 1.

You could utilize a formula tile or a beast mode (if you want to apply filtering dynamically to your calculation) to calculate it: `Approved` / (`Approved` + `Refused`)

Hi @LiliRestrepo I'd recommend looking into structuring your data differently to use a custom date dimension table. This will allow you to have data to compare it to the same timeframe from a year ago while allowing date filtering to still work properly. I've done several write ups of this in the past but you can find more…

Agreed, This can tie in with https://dojo.domo.com/main/discussion/comment/55344 to get release notes in general (for all things being released not just the major big flashy things).

Having one audience per record. Something like: C-Suite | 19 | Enterprise VP | 19 | Enterprise Director | 19 | Enterprise You could utilize Magic ETL 2.0 formula tiles to use the SPLIT_PART function and grab each entry in your CSV list and then append each of those formula tile outputs to each other.

You can calculate the length of the string, remove the character you want, recalculate the length and take the difference. LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1

Can you apply an aggregated filter to have count of your metric be greater than or equal to 10? You can set the filter in each of your drill downs to be the minimum value you're looking at.

How exactly does Domo Everywhere work? Is it an add on that you purchase to basically iFrame a dashboard to an external website? Simply yes, there are two different versions of Domo Everywhere / Domo Embed - There's a private embed which allows you to utilize an iFrame but requires users to have a Domo license. Then…

Alternatively you could restructure your data so you have one record for each audience to allow you to count, filter and group by the different audience types easier.

There isn't a way to dynamically hide or show a card based on a filter condition. I'd recommend adding it as an idea to the Idea Exchange.

You'd have to have an Admin move the pages under the Admin - Pages section to change the parent page of the pages you wish to move.

You'd need two separate jobs, one for hourly append and one for monthly replace updating the same dataset. There is some risk involved with this as it can cause them both to run at the same time and get unexpected results. What you can do is limit the hourly job to run in between certain hours and then once a month or…

You can use a window function or fixed function to calculate the row number. The following example will rank them based on the Total Revenue column. You can replace that column with others to get the row number based on other values. This won't take into account ties. SUM(SUM(1)) OVER (ORDER BY `Total Revenue` DESC)

Google represents dollar amounts as micros. $1.00 = 1,000,000 micros (or $0.01 = 10,000 micros) so if you want to convert it to cents divid your value by 10000.

It's been around for a while but can be easy to overlook. Glad I could help. If you could accept the answer so others can hopefully find this easier in the future I'd appreciate it.

You can download the dataset as a a CSV and open it it Excel. Go to the Data tab on the dataset, click the three dots in the upper right and then select Export Data. As for your error - do you have your instance name put into the customer field correctly including the https:// prefix? For example:…

Hi @CarolineRogg1 It sounds like you want a Trellis chart. You can read up on these here: https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6.

Here's a REGEX version: Something like this might work for you in a formula tile in Magic ETL 2.0: REPLACE(REGEXP_REPLACE(`landing page url`, '^.*ufhealth\.org\/([^?]+).*$', '$1'), '-', ' ') It's looking for your base URL and then pulling everything after it until it finds a ? character and ignoring everything before and…