MarkSnodgrass Coach

I would suggest you look into either of these options and see what makes the most sense for you. Both of them revolve around taking data from multiple columns and putting them in a single column. Approach 1 - Use the Magic ETL Collapse Columns tile…

You should have as long as you would like to take an exam after you purchase it. However, certifications only last for 1 year, so you would want to pass the higher level exams that require completion of the lower level exams while you are still certified on those.

The first thing I would look at is changing your initial dataset that is populated by the MariaDB Connector from replace to append. Go to that Connector Dataste and click on Settings and then Update Mode and see if that is set to Replace. Try changing that to Append. This will append each day's data to this dataset and you…

Are you using something like Domo Workbench to query your source data and then pushing it to Domo? If so, you could limit your query to just the previous days data if you have a date column in your dataset by using a WHERE clause like: WHERE TransactionDate = GETDATE()-1 In Domo, you can set your dataset to append rather…

You could create another dataset in the Magic ETL that has your filter applied and then go to that dataset in the data center and export out that data by clicking on the export option in the top right. Other than that, I typically just create a pivot table or mega table card on my overview page where no one else can see my…

Support got back to me and they have implemented the fix. It is working in my instances now and should be working in anyone else's now as well.

The Campaigns app is intended to be used for e-mail marketing campaigns while making use of your data in Domo. Think of it like a Constant Contact version of Domo. Your Domo CSM should be able to set up an in-depth look into it. You can also look at the KB documentation here to better understand its features.…

I have submitted this to support and created a case. I will let you know what they say. Thanks for letting me know it is happening in other instances.

As long your datasets share the same column name that you want to filter on, you can use the checkbox filter (or other filter cards) to apply a filter to multiple cards at once on a page.

I use the connector and I see it in the app store. I clicked on the Search icon on the left and chose Connector in the Capability section and then searched for Microsoft. It came up with several others. If you replace your instance name in the URL below, it should take you there as well.…

Brilliant @jaeW_at_Onyx ! I created the following beast mode: (CASE WHEN COUNT(DISTINCT `state name`) = 1 THEN CONCAT('Total Estimated Cost for ', `state name`) ELSE '' END) and dropped this beast mode into the Category field of the dynamic textbox and then just display the First Category in the General - Text properties.…

I know the Utah Jazz did what you are doing about a year ago. They briefly showed at DP19 and then on a Domo Voices spotlight webinar. It is tedious work and I'm guessing they hired Domo to do the detail work. @jaeW_at_Onyx and @GrantSmith are both right. You need to correct your SVG file. You can do this with Adobe…

I think you can accomplish this by making use of the various chart properties, sorting, and filtering capabilities and not have to worry about a beast mode. Try this: 1. Set your Date Range filter back to all time 2. Drag your date field into the Sorting section and sort by ASC and make sure it is set to No Aggregation. 3.…

If you have Microsoft Office 365, I would suggest using Microsoft Forms. You can then use the SharePoint Connector in Domo to pull the form results that are stored in Excel. Microsoft Forms lets you set up dropdown lists, required fields, etc. that can better control data input than an open ended worksheet. Here is a…

You are going to want to use the Uncollapse Columns tile in the ETL to do this. The KB has a nice walkthrough on how to do this. Here is the link: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns#Uncollapse_Columns

On the schema tab in the dataset job in workbench, what data type is Domo assigning to it?

Window functions are available in beast mode, but they are not turned on by default. Ask your CSM to enable "window functions in beast mode". They will get enabled and then you should be do it. You won't have any intellisense when you type, but the functions will validate.

@MartinB Did you check your formatting options in in the optional value field? You can control what data type it should be and the decimal places just like you do on any other card. You can even choose percentage, so you don't have to do any beast mode gymnastics. 

If your datasset is powered by a Magic ETL, this is pretty easy. Just add a Select Columns tile and alias the field that you want to use as the name of the field that is currently being used in your cards. Then, rename the current field to something else, or just remove it in the Select Columns tile. Make sure you match…

From my experience, the linked cards are showing up because you used the Save As feature to create a new card. If you want to remove a card from being linked, you can hover over it in the list of linked cards and click on the trash can in top-right corner of the card. 

Workbench works the other way in that you name your dataset in Workbench and then push it up to Domo and the datasets will show up in Domo with the names you gave it in Workbench. This may be helpful if you haven't already looked at it.…

The date filter doesn't lend itself to do this, but you can pull this off and keep it dynamic by making a beast mode that use as a quick filter. Here is the formula to create: /*check to see if it is the 1st of the month */ (CASE when DAY(CURRENT_DATE()) = 1 then /* it is the 1st of the month so only include data from the…

Just add Advertiser in your group by tile in the same section where you added the week number and year. It will then sum the revenue by advertiser, week number, and year.

I believe I have run into this issue when it didn't know what Domo instance I was associated with. If you didn't already, log into your domo instance and then navigate to the help center and then click on support. I am seeing my open support tickets right now when I go there, so I believe it is having trouble…

To group by week in the ETL, you will want to use the date operations tile. Drag that tile in and select week of year and name it week number. I would also add another column to get the year and select year of date in the date function. In your group by tile, group by those two columns and sum your revenue. This will get…

Unfortunately, the dashboard filters are set to work on an AND condition. Maybe not ideal, but you could could have one card that shows states totals and another card that shows region totals and have them sit next to each other in your dashboard. If you are using the filter cards, you can tell it which cards should be…

Unfortunately, you can't do totals like this in beast mode. You will need to do this in SQL or Magic ETL. It would be a nice enhancement if beast mode could eventually grab these totals as it is a common question.

I see in your attachment in the first screenshot that the dataset contains 61,598 rows. What is the row count of the dataset in your last screenshot where you are filtering on nulls and there are no rows for that filter? Is it the same? If so, then you didn't lose any rows.

In the appstore, you can add the Domo Dimensions Connector. It has a dataset of dates that you can then use to join with another dataset so that you have all dates in a range of years that you need. You can find it in the appstore by searching for calendar or Domo Dimensions

@GrantSmith gave a very nice walkthrough so not too much more to add. If you haven't looked that the KB article, it gives a nice step by step guide that may help you. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow You can also do recursive dataflows in Magic ETL.…