GrantSmith Coach

Currently this isn't an option as you're only able to drill with both values being filtered. I'd recommend adding this as an idea under the idea exchange section of the Dojo so the product team can utilize your feedback for their roadmap and to allow others to vote for this idea.

There are perks for having something as a beast mode and perks for having something in an ETL. If something needs to be recalculated on the fly utilizing a filter then I'll go with a beast mode. Most of the time I'll try and put calculations into the Magic ETL so that the processing may take a fraction longer to prepare…

You can try and utilize the General - Fill Empty Data Cells with 0 settings on your pivot table to fill the blanks with a 0 and then try and compare to 0 for your color rule.

The user who you authenticated workbench with is the owner and must either share the dataset with you or make you the new owner for you to see the dataset.

No Sumo cards are still used and can load more data easier than the pivot table but the don’t have as many features. Also Sumo tables are how you can read encrypted data. That’s not possibly with the pivot table. Short answer is that sumo tables are still around and have uses.

When indexing you typically want to look at the combinations of fields being used within your joins. This will allow the join to look up the data faster to be more performant.

Pydomo doesn't support setting/uploading profile images. You could monitor the network traffic to determine what the API call it's making to then replicate in your python script with a package list requests. I had done this in the past but can't find the endpoint. You will need to make sure you set the Content-Type…

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…