MarkSnodgrass Coach

You might want to look into the AutoML feature in Domo. If it isn't enabled, you can ask your CSM to enable it as a trial.

You can use a beast mode to exclude dates prior to today by doing this: CASE WHEN startdate < CURRENT_DATE() THEN 'Exclude' ELSE 'Include' END You would drag this beast mode into your filters and filter to Include. You could also choose to use enddate instead, so it wouldn't show all past projects. However, your 2nd part…

That is odd. I would suggest creating a beast mode that results in numerical values to put in your sorting. For example, I would do something like this: CASE WHEN Preferred = 'Yes' THEN 1 ELSE 0 END Put this beast mode as your first sorting and sort descending and remove the Preferred from the sorting. See if this does the…

Federated datasets are typically fully materialized and come from another Domo instance or from Snowflake, etc. They currently can't be used in ETLs because of how Domo stores the data. If you are using Workbench, these won't be federated datasets and you can use Magic ETL on these datasets to combine or manipulate them.…

You can install Workbench on a VM. That's where mine is installed. Just needs to be any Windows OS. A VM would be the best location because, as you said, if it is on your laptop, then it will only run when your laptop is on and connected to the internet.

Personally, I would make a plan to migrate all of your datasets over to Workbench so that they all run through that. Your security should like that better actually. As far as the SQL connector, if you have some that are running and some that aren't, if you have verified that they are all configured the same, then you might…

I would suggest using Workbench if you are able. It is very easy to use. With the SQL connectors, you are going to need to make sure the correct firewall ports are open, which can be challenging for some organizations. In Workbench, you can create an ODBC connection and then use the connection for your connection string.…

Are you using Domo Workbench to connect to your SQL database? Or are you using a connector that you choose from in the Data Center?

You can use the Line + Grouped Bar to have your bars plus lines as running totals. You will need to edit your chart properties to this:

Listagg is not a supported function in beast mode. You can use GROUP_CONCAT in a MySQL dataflow as an alternative. You could also look to use the pivot/unpivot tiles in Magic ETL as another option.

Yes, many people are dealing with it right now. Seems to be timed as to when Domo pushed out an update. Brought a lot of things to a crawl. Some people are starting to see an improvement. I expect Domo to have it worked out in the next hour or so.

Agree with Michelle that you should use the timezone transformation if you actually need the time. If you don't actually need the time in your analysis, go the schema tab and change the data type from datetime to date. When it is just a date field, Domo won't try and apply any timezone shifts to that field.

Unfortunately, it's definitely not on the admin page of your screenshot and I don't see that as a field in Domo Stats or Domo Governance to be able to build a card that would tell you which ones need locking. Looks like a good suggestion in the Ideas Exchange as you suspected.

Definitely interested in seeing more about app studio. Would like to see more about the office add-in and how someone has really taken advantage of it besides adding a single card.

Domo has a lot of free classes available in their University section of Domo Central (click on University at the top of this page or go to ). You can choose to learn by skill or role and look for the free ones. Domo is also doing a Domo Customer Orientation workshop that is online and free. Your CSM should have information…

I would suggest pivoting the data in Magic ETL so each day is a row and then you can use the rank & window tile to create a running total. This will allow you to easily determine which day you broke even on. You can then pivot it back to your original format if you really wanted to. However, I would instead suggest keeping…

Are you receiving alerts on other cards or datasets? I would try creating a test dataset or card and creating an alert and then changing the data that forces the alert and make sure that you receive it. You can use the Domo Webform to quickly create a dataset and update it, or you could upload a sample Excel file. This…

@marcel_luthi they key to consecutive days is to add the Domo Dimension Calendar which has a row for every day. Joining your data to that will ensure consecutive days.

In the activity log dataset, you would look for where Action = 'CREATED' and Object_Type = 'PAGE'

I believe you can make a request to your CSM to allow you to schedule them to run more frequently, but they are not configurable by default.

Done… but not as fast as Grant and Michelle (unsurprisingly) 😁

I might end up making this as a separate idea in the exchange, but we need the ability to sort the items in the variable dropdown list. They don't automatically sort alphabetical and if you don't enter them in the right order the first time, you are stuck with that order. Just tried removing items and then adding them back…

I have a custom chart, but I use the standard themes. I just created a new card and chose my custom chart and selected custom color ranges and it worked without issue. Did you try creating a new card from scratch to see if that is successful?

The line chart does have series option and you would put your 2nd value in the series and choose an aggregate option. It looks like Analyzer didn't fully change chart options after you changed what chart you initially started with. Try removing the field from the y-axis and then add it back. This usually refreshes the…

There isn't a native chart type that would provide that layout. You might want to look at the Domo Bricks to see if there is something that would do that. If you are familiar with Javascript, you could use the Domo Blank Brick and build the bullet list array to pull this off. You could also look at the notebook card, but I…

You can use the new Office add-in to have your Excel file be a dataset in Domo. You would then power your card off of that dataset in Domo.

You can use Michelle's suggestion to exclude today dynamically and then you can use the date range filter on the card and choose last 3 days or last 2 days, which can be easier to maintain and is an easier visual cue for the end user to know the data range of the card. It also allows them to change it to other date ranges,…

You are right, that doesn't look great. I was expecting your "x-axis" to be grouped by day and not by each individual time element. You might need to create a beast mode for your dates and use the DATE() function to remove the time element. This would consolidate things a bit. Add this date beast mode to your chart and to…

The y-axis can't be text for this type of graph. You might want to consider using the heat map chart type. You can use your text labels for the "y-axis" and then use your numerical values in the sorting properties to get it to be displayed in the low to high order that you want. Here's the KB article.…

I would put your numerical value field in the values field of the card and then put your text field in the Tooltip Field and then use the Data Label Settings in the Chart Properties to display the Tooltip Field.