GrantSmith Coach

Currently it's not an option until they allow group ownership of datasets. You could utilize an email address that would then forward emails to a group but that would have to be handled in your email server outside of Domo.

Are you using RANK in a window function? It sounds like you don't want any missing numbers in your sequence. Rank will ignore numbers if there are ties in your dataset. In this case you might want to try DENSE_RANK instead as that won't have any skipped rank numbers.

Hi @SLam I'd recommend reformatting your data with a date offset dimension dataset and using a beast mode to calculate the different between last year and this year. I've written about this before here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest You can then…

It doesn't appear Domo has a connector already written for CMiC but you could write your own custom connector to pull the data in. You can get more information by https://developer.domo.com on creating your own custom connector. Alternatively you could use a Python script to communicate with the API outside of Domo and…

Currently there isn't a simple way to do this and it must be done manually.

It sounds like your data might actually not be null but an empty string. Try something like this to handle empty strings and strings with just spaces: WHEN COALESCE(TRIM(`Building Status`), '') = '' THEN 'XYX' coalesce returns the first non-null value in the parameters supplied. This forces null values to be an empty…

You can’t change how the data is displayed conditionally based on the type of chart selected. You can graph it as a bar chart and by default it will display the raw data table when the user clicks on the card in the details view.

There isn’t a way to switch the color on a single line however I’ve used two lines with the same values and a beast mode to conditionally display certain values. You’d use your metric as the weekday which would display the weekend and weekdays. CASE WHEN WEEKDAY(`Date`) IN (1,7) then `Metric` END you’ll have to play around…

Use the LIKE command instead of <>

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.