MarkSnodgrass Coach

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.…

@swagner What if you did this? case when `Description` = UPPER(`Description`) then 'All upper' else 'Contains lowercase' end If your descriptions come in as all uppercase then it should match on the first when statement. Otherwise it wouldn't match because your description contains a lowercase letter and fall into the else…

Yes, you can do this in the ETL by grabbing the month and year from a date column and then re-construct a date column as the first of the month. Here is a screenshot of a sample dataflow that shows the steps and then I will explain what is going on in each step below. Date Operations: Add a column called Month and use the…

If you go to date range filter in the card analyzer, you can tell it to group by month. This will group it by month and year and automatically the sum the totals for you. This KB article may help you.…

Are you trying to show on your x-axis the days since Feb 22nd so that it would display 1, 2, 3, 4, 5, etc...? If so, you would need the dates for each of those days in your dataset and then you could do a datediff between that date and Feb 22nd. What columns do you have in your dataset? Also, if you do have the dates in…

You would still make use of the CONCAT function. It would just look like this to incorporate the field_ID. CONCAT('https://na132.salesforce.com/','field_ID')

@Ashleigh Unfortunately, it is looking like the functionality for the poll card is quite limited. It looks like it only supports anonymous answers and it doesn't look to store the answers in the data center.

You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this: (CASE when TRIM(`City`) = 'Abbeville' then 1 when TRIM(`City`) = 'Phoenix' then 1…