GrantSmith Coach

You'll need to utilize a calendar dimension dataset. Domo has one in the Domo Dimensions connector (calendar.csv). This has all the dates from 2010-2030. I'd recommend filtering the dataset to be before the current date and after or equal to the start date of your data. This will reduce the extra rows which won't be…

You can use the formula tile in the new magic ETL version to apply the DATE function. Alternatively you can use Alter Columns to change the data type of your columns to Dates

You can multiply amount by 1 to force it to be a number or change the data type in an ETL

If you're looking to do this per customer you can utilize a Rank & Window tile and use the LAG function to get the prior record's value. You'll want to partition based on the customer ID. Then you can use a formula tile to calculate the difference between you current version and the lag version. Then put that into a Group…

When looking at your data set what data types does it show for those two fields?

Currently there isn't a way to copy conditional color rules across datasets. I'd recommend posting an idea to the idea exchange for other users to vote on and help direct the Product team to desired enhancements. https://dojo.domo.com/main/categories/ideas

This is a great idea. I’d recommend posting this to the idea exchange (https://dojo.domo.com/main/categories/ideas) for the product team to see.

Try creating a beast mode with a window function and then filter the value to be 10 or less This will calculate the row number base on the highest amount total being first for each department SUM(SUM(1)) OVER (PARTITION BY `Plant Department` ORDER BY `AMOUNT TOTAL` DESC)

You can use a window function to keep a running total and then divide them SUM(SUM(`Cases Closed`)) OVER (ORDER BY `Year`, `Month`) / SUM(SUM(`Total Cases`)) OVER (ORDER BY `Year`, `Month`)

You need an END after 'Count' before the last closing parenthesis.

Have you tried using FILTER NONE as part of the FIXED function to prevent all filtering on your window function?

@Joe_M When the page level filter is applied it is ignoring all of the old data and only filtering for those exact dates. The prior year or month data is filtered out which is why you're getting nothing for those card. This is why I will create my own date dimension table to better handle period over period type…

@Sam_Donabedian INITCAP is available in views however it's just not listed in the available functions.

Because order by is required it's not possible to to a grand total. Currently the way is to use a group by and then join it back to the dataset.

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