MarkSnodgrass Coach

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.

What do you mean by alias? If you are referring to referencing one beast mode within another, that can't be done in Analyzer, but it is something that has been suggested in the Ideas Exchange. The CONCAT function follows this format: CONCAT(expression1, expression2, expression3,...) An example would look like this:…

You can create the user as a Social User, which is free, and then share the dashboard with them via Buzz.

If you are referring to when you export a table card to Excel, it is worth noting that Domo added a new chart property that allows you to go up to 500k rows now.

You might try looking at this video to see if it is helpful for you. @Ellibot has a couple videos around slack integration that might be useful for you.

I would not use the -1 as that is going to just change it from July 31st to July 30th and is not what you want. I would use this to get the previous month: LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 month)) Also, in your NULLIF function, your 2nd parameter is just inserting a blank. That will be problematic as a denominator.…

You have a lot of parantheses going on so it is a little hard to tell, but I don't think you have a second argument for your NULLIF function. Additionally, I would recommend evaluating months by using the LAST_DAY() function instead of just the MONTH function. Depending on the date range of your data, you can be looking at…

The totals and subtotals tend to follow the aggregation type used on the field itself. If you switch to average, your subtotal should show the average. Additionally, you may want to look at using the additional aggregation types available on the field that allow you to show the percent of the row or column for that field.