MarkSnodgrass Coach

Yes, you can do this in Magic ETL or MySQL. I am going to assume you want to do this in the Magic ETL. If your data only has values in only of those 3 columns, you should try using the combine columns tile. If your data has values in 2 out of the 3 or all 3 and you want to prefer column c when there are multiple values,…

I would suggest the pivot table card so that you can get it in the layout you want. I would also make Building Number a quick filter and then click on the wheel cog of that quick filter and choose Single Select, so that they can only choose one building at a time.

It looks like you have the ability to edit toggled off. In the analyzer, there is a row of icons that let you hide different parts of the analyzer to give you more screen real estate to edit. Click on Summary and you should see the Summary Number return to be able to configure it.

You can do this pretty easily in a beast mode. If an empty column is truly null, you can use multiple IFNULL statements, starting with column C since that is your preferred column to use. IFNULL(`ColumnC`,IFNULL(`ColumnB`,`ColumnA`)) If you don't have null values, but there are filled with empty spaces, you could build a…

You can copy existing ETLs. In the Data Center, click on the Dataflow icon on the left. Find your ETL in the list and click on the wrench on the right and choose Create Copy. You can then edit the newly copied ETL and give it a new name and new output dataset name. 

You could use a Running Total card to automatically build the cumulative totals for you. You could also create a beast mode called DisplayDate (or whatever makes sense to you) that just has a AddDate function in it that would display the next months name instead of the month it is in. This function would do it…

@sdarmody You might be able to pull this off with a Heat Map card. Here is a basic example. Use your date for category 1, your count of tech support incidents for the value, and then a company name or something that doesn't have multiple values for category 2 so that your don't have multiple rows. You could create a beast…

When you create a beast mode and click on the check box, "share calculation on dataset", it will only show up in the card analyzer when that dataset is selected. They don't ever show up in the Magic ETL. You can, however, copy beast modes from one dataset to another by changing datasets for a card in a specific way. Here's…

@sdarba That does seem quite odd. I would reach out to Domo Support to get an answer from them. Unless you have an input dataset that this dataflow relies on that isn't finishing in time, it seems like you should be able to have it run at the specificed time. 

I'm not aware of a way to favorite on a user's behalf, but here is a way to get around that: Create a new page called "old" or whatever you like and move the cards that are on the page that everyone to this newly created "old page". Next, move the cards that are on your new page to the page that everyone has favorited.…

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.